| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I condense 3 columns into 1 in Excel?
I have an excel spreadsheet with contact info that I am importing into
outlook. Right now, my address' are in 3 columns (number, street, designator). How can I combine the 3 columns into 1 column so that the address is all together? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I condense 3 columns into 1 in Excel?
Assuming your data is in columns A, B and C, enter following formula in D1,
then copy down: =A1&" "&B1&" "&C1 HTH -- AP "Niki" a écrit dans le message de ... I have an excel spreadsheet with contact info that I am importing into outlook. Right now, my address' are in 3 columns (number, street, designator). How can I combine the 3 columns into 1 column so that the address is all together? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I wrap Excel columns in a printout? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Linear Mode
