How can I merge 3 cells into 1 cell?

[Guest]

Basically I have 3 different cells that include address city and state. I
need to merge these cells into 1 cell and be able to show just the 1 new cell.

 

[Peo Sjoblom]

=A1&" "&B1&" "&C1

 

[Guest]

Assuming your address is in A1, your city is in B1, and your state is in C1:

Select cell A4 and use the following formula:

=A1&" "&B1&", "&C1

 

[Gord Dibben]

Lucky

A note of caution here.

As noted by the other resonses this is easy to do but most applications that
interact with Excel like the data to be in separate cells..........like for
instance a mailmerge in Word or similar.

You will also make it much more difficult to sort or filter with all data in one
cell.


Gord Dibben MS Excel MVP