View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Damien McBain[_2_] Damien McBain[_2_] is offline
external usenet poster
 
Posts: 49
Default 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