Merging text strings into a single cell

  • Thread starter Thread starter JulieD
  • Start date Start date
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
 
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?????
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summarizing data from various workbooks 3
Referencing a cell even if its contents are moved moved/replaced 6
Sumif merged cells 4
Merge the same group of cells down a column quickly 9
"uncombine" data in a cell 5
Display only unique values in CONCATENATE formula 4
Updating a cell 1
Data merging from two cloumns into one 10

Back
Top