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.

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


--
Regards,

Peo Sjoblom


"Lucky1423" wrote in message
...
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.

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

"Lucky1423" wrote:

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.

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


On Tue, 1 May 2007 11:28:01 -0700, Lucky1423
wrote:

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.