| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
separate text into different cells
I have text in an excel spreadsheet that I need to separate into different
cells. I don't know what function to use or how to set it up. It is formatted like this in one cell: City/State/Country Thanks in advance for your help! |
|
#2
|
|||
|
|||
|
I'd select that column
then data|text to columns delimited by: / (make sure that there are empty columns to the right) yamareezy wrote: I have text in an excel spreadsheet that I need to separate into different cells. I don't know what function to use or how to set it up. It is formatted like this in one cell: City/State/Country Thanks in advance for your help! -- Dave Peterson |
|
#3
|
|||
|
|||
|
SUPERB! EXCELLENT! Thank you so much! You have made my day! Have a great
afternoon! "Dave Peterson" wrote: I'd select that column then data|text to columns delimited by: / (make sure that there are empty columns to the right) yamareezy wrote: I have text in an excel spreadsheet that I need to separate into different cells. I don't know what function to use or how to set it up. It is formatted like this in one cell: City/State/Country Thanks in advance for your help! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not all pasted text appears in cells | Excel Discussion (Misc queries) | |||
| Using text in cells to build a link to within another file | Excel Discussion (Misc queries) | |||
| Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| counting text cells | Excel Worksheet Functions | |||
Hybrid Mode
