Combining Data in Multiple Cells
 

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

Combining Data in Multiple Cells
 

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

Combining Data in Multiple Cells
 

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


www.Geocities.com/UDQServices
Free Data Processing Add-in<
===== * ===== * ===== * =====

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

Combining Data in Multiple Cells
 

Something like this...

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

The "&"operator concatenates the items together.
--
HTH...

Jim Thomlinson


"childofthe1980s" wrote:

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

Combining Data in Multiple Cells
 

Try something like

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


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




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