| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split Data in One Column Into Two
Smashing
"Kevin B" wrote: Click DATA on the menu and select TEXT TO COLUMNS. In the next dialog box indicate that the file type is delimited (default) and click the NEXT command button. Click the COMMA checkbox and click the FINISH command button to complete the process. The data will be parsed into 2 columns and the trailing comma is automatically removed. -- Kevin Backmann "RoadKill" wrote: 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? |
| Reply |
| 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 | |||
Hybrid Mode
