How can I merge 3 cells into 1 cell?

L

Lucky1423

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.
 
S

spence

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
 
Top