| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split Data in One Column Into Two
Hello,
We have data that is last name first separated by a comma so it looks like this: "Schmoe, Joe". What we would like to do is take the first name (currently in column A) and move it over to column B while leaving the last name in Column A. Any easy ways to do this without manually going through thousands of records? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split column | Excel Discussion (Misc queries) | |||
| Split data in column | Excel Worksheet Functions | |||
| split a column | Excel Discussion (Misc queries) | |||
| How do I split data in a column (formula)? | Excel Discussion (Misc queries) | |||
| How to split one column into two? | Excel Worksheet Functions | |||
Threaded Mode
