| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I combine the contents of two columns?
Hi,
With a choice between =A1&" "&B1 and =CONCATENATE(A1," ",B1) I would opt for the first one ontil Microsoft allows us to use it like this: =CONCATENATE(A1:B1) -- If this helps, please click the Yes button Cheers, Shane Devenshire "Robert Judge" wrote: I have two columns in Excel 2003 containing address information: Column 1 Column 2 123 Main Street How can I combine these into a new column that will state "123 Main St."? I will appreciate advice. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine contents of multiple rows in one row | Excel Discussion (Misc queries) | |||
| How can I combine cell contents? | Excel Discussion (Misc queries) | |||
| I am trying to combine contents from 2 cells into 1 | Excel Worksheet Functions | |||
| Combining cell contents when there is content to combine | Excel Discussion (Misc queries) | |||
| Combine the contents of two cells. | New Users to Excel | |||
![Shane Devenshire[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
