| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheets
Is it possible to merge columns in Excel. Eg. Column A - first name, Column
B - last name. And merge to have full name. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Spreadsheets
You can't merge the columns but you can concatenate the strings.
In column C type in =A1&" "&B1 You can add a comma between the " also to separate the names Then copy and paste that formula "Janmar" wrote: Is it possible to merge columns in Excel. Eg. Column A - first name, Column B - last name. And merge to have full name. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel spreadsheets | Excel Worksheet Functions | |||
| Excel spreadsheets over WAN | Excel Discussion (Misc queries) | |||
| Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
| Excel Spreadsheets | Excel Discussion (Misc queries) | |||
| EXCEL SPREADSHEETS | Excel Discussion (Misc queries) | |||
Hybrid Mode
