merging two cells without loosing data

M

mm

If i have data in cell a1 that says "1234 brown st" and data in cell a2 that
says "Anytown, WY 12345", how do I merge the two cells and not loose any data
so that cell a1 will have the value "1234 brown st Anytown, WY 12345" ???????
 
D

Dave Peterson

I'd use a helper column of cells and hide column A:

=a1&" "&b1

I'd keep the data as granular as possible. It's really easy to concatenate--but
can get real hairy to separate.
 
Top