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

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

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

"childofthe1980s" <childofthe1980s@discussions.microsoft.com> wrote in
message news:F2AAADF0-44AF-40DA-A804-6FC7D3584A28@microsoft.com...
> 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

"childofthe1980s" <childofthe1980s@discussions.microsoft.com> wrote in
message news:F2AAADF0-44AF-40DA-A804-6FC7D3584A28@microsoft.com...
> 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

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

Try something like

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


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




"childofthe1980s" <childofthe1980s@discussions.microsoft.com>
wrote in message
news:F2AAADF0-44AF-40DA-A804-6FC7D3584A28@microsoft.com...
> 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