| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using CSV to break up text into multiple columns
I have an excel spreadsheet with first and last name in the same column.
ie:smith,jon. I need to have the last name in one column and the first name in the next. How can use .csv to break this into 2 separate columns: cell a1=smith, cell b1=jon (I don't know anything about using 'comma separated values' so any detail info would be greatly apprecaited! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining multiple columns of text | Excel Discussion (Misc queries) | |||
| Text to Columns - moves text up | Excel Discussion (Misc queries) | |||
| convert text labels to excel columns | New Users to Excel | |||
| Text To Columns | Excel Worksheet Functions | |||
| splitting text to multiple columns | Excel Discussion (Misc queries) | |||
Threaded Mode
