G
Guest
Is there any way (and if so, how) I can merge two or more cells with data in
them and not loose data?
them and not loose data?
C
Chip Pearson
No.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
G
Guest
Well - Great.:-{
I was hoping.
Have a great holiday.
I was hoping.
Have a great holiday.
C
chrisnelsonusa1
You could concatenate the two cells together instead of merging them. I
the two cells are A1 and B1 the equation goes like this.
=concatenate(A1,B1)
That will take the information from cell A1 and merge it with B1 an
anything else you want to add to all the cells can be added by puttin
another comma in and specifying what you want to add, i.e.
=concatenate(a1," ", b1) - would put a space between the two pieces o
text.
=concatenate(a1,"-",b1) - would put a dash between the two pieces o
text.
=concatenate(a1,b1,"This is cool") - would put This is cool after th
two pieces of text.
Hope that helps
Chri
the two cells are A1 and B1 the equation goes like this.
=concatenate(A1,B1)
That will take the information from cell A1 and merge it with B1 an
anything else you want to add to all the cells can be added by puttin
another comma in and specifying what you want to add, i.e.
=concatenate(a1," ", b1) - would put a space between the two pieces o
text.
=concatenate(a1,"-",b1) - would put a dash between the two pieces o
text.
=concatenate(a1,b1,"This is cool") - would put This is cool after th
two pieces of text.
Hope that helps
Chri
E
Excel_God
Yes there is! 
Two fields containg data, can be merged like this:
A1 B1 C1
123 456 =A1&""&B1
Just write =A1&""&B1 in to the C1 cell.
Two fields containg data, can be merged like this:
A1 B1 C1
123 456 =A1&""&B1
Just write =A1&""&B1 in to the C1 cell.