Combining Data in Multiple Cells

[Guest]

Hello:

I have city, state, and zip in three different cells. I want to combine
that data into one cell with a space between city and state and a space
between state and zip code.

What formula would I need to write to accomplish this?

Thanks!

childofthe1980s

 

[Damien McBain]

Hello:

I have city, state, and zip in three different cells. I want to combine
that data into one cell with a space between city and state and a space
between state and zip code.

What formula would I need to write to accomplish this?

Thanks!

childofthe1980s

=a2&" "&b2&" "&c2

 

[Daniel CHEN]

Suppose A1 has city, B1 has state and C1 as zip then use the following
formula:

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

You can use "," to replace space (" ") if you want.

===== * ===== * ===== * =====
Daniel CHEN

(e-mail address removed)
www.Geocities.com/UDQServices

Free Data Processing Add-in<

===== * ===== * ===== * =====

 

[Guest]

Something like this...

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

The "&"operator concatenates the items together.

 

[Chip Pearson]

Try something like

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"childofthe1980s" <[email protected]>
wrote in message
news:[email protected]...