Merging text strings into a single cell

J

JulieD

Hi

you're very close for strings we use the &
so either
=A3&B3
or
=A3 & " " & B3
if you want a space between them

Cheers
JulieD
 
B

Big Momma Excel User

HELP!!!! I have created 2 separate columns of text data in a large spread
sheet (over 600 rows of data). Now I need to merge the 2 columns together so
that the text descriptions from each column are combined together into a
single column.
If the cells were numeric it would not be a problem (i.e. if C3 were the
finished result I was looking for cell C3 would read "=A3+B3. Only problem is
Excel simply tells me the formula is invalid because it's text data. Merging
the cells of each row simply cuts the text off from the 2nd cell. How can
this problem be resolved?????
 
Top