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) |