Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data separation
I currently have a spread sheet that has the first and last name in one
column as, Smith, John. I really need to break these names apart and have them populate two separate colums. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data separation
Hi,
Highlight the column then do text to columns, delimited, check the box that says comma, next, finish it will split in two columns if this helps please click yes, thanks "CandiC" wrote: I currently have a spread sheet that has the first and last name in one column as, Smith, John. I really need to break these names apart and have them populate two separate colums. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mean separation by LSD value | Excel Worksheet Functions | |||
name separation | Excel Worksheet Functions | |||
Value separation and then adding | Excel Worksheet Functions | |||
Cell Separation | Excel Worksheet Functions | |||
Decimals separation "." and "," | Excel Worksheet Functions |