| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining data in multiple cells | Excel Discussion (Misc queries) | |||
| Combining data from multiple cells into one cell with commas | Excel Discussion (Misc queries) | |||
| Combining data from multiple cells into one cell. | Excel Worksheet Functions | |||
| Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Linear Mode
