| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting up information in a cell
how can I split up one cell containing first and last name into individual
cells for each of them? I have a file that has names in one cell and I want to seperate them so that I can sort them. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
splitting up information in a cell
If they are separated by a delimiter, such as a comma, you can use the text
to column function. You should find this in Main Menu: Data: Text to Column: Delimited -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "dmedina" wrote: how can I split up one cell containing first and last name into individual cells for each of them? I have a file that has names in one cell and I want to seperate them so that I can sort them. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| splitting cell | Excel Worksheet Functions | |||
| Process for splitting information in a cell(s) | Excel Discussion (Misc queries) | |||
| Splitting Information in a Cell | Excel Discussion (Misc queries) | |||
| I'm stumped, splitting up a clump of text into useable information | Excel Discussion (Misc queries) | |||
| Splitting a Cell | Excel Worksheet Functions | |||
Linear Mode
