Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

concatenate

Status
Not open for further replies.
jiminy

jiminy

Technical User
Jan 26, 2002
30
0
0
US
In Excel 2007, I have the hardest time with CONCATENATE. I have 2 columns of text that I want to concatenate together (row by row). If in cell C2 I enter

=CONCATENATE(A2,B2)
the result is just THAT-- As if I had put quotes around the whole thing.
 
Sort by date Sort by votes

Sounds like the cell is formatted as text.
Change it to General.


Randy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Concatenate (i think) records into one text box 1
Replies
5
Views
54
Moss100
Moss100
sweetkel23
  • Locked
  • Question
MS Access concatenate and trim 1
Replies
7
Views
73
sweetkel23
sweetkel23
fredka
  • Locked
  • Question
Concatenate Names
Replies
1
Views
48
PHV
PHV
kc112
  • Locked
  • Question
concatenate records in a query help 2
2
Replies
24
Views
135
dhookom
dhookom
molly
  • Locked
  • Question
Concatenate with good lineups 1
Replies
4
Views
44
molly
molly

Part and Inventory Search

Sponsor

Back
Top