| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
split text into separate cells
I have a list of book titles that came over all in one cell. I would like to
separate them into individual cells, one title per cell. They are separated into lines using the "alt-enter" command to advance by one line when entering text in a cell. If I can find a way for excel to recognize the "alt-enter" in the text then i think i can do it with the find command. Any ideas? Thanks in advance. John T |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can text in one cell be split into several cells? | Excel Discussion (Misc queries) | |||
| Split date in cell into 2 separate cells | Excel Discussion (Misc queries) | |||
| Split data from one cell to two separate cells | Excel Worksheet Functions | |||
| separate text into different cells | Excel Worksheet Functions | |||
| text cells end page how split to next. Text lost! | Excel Discussion (Misc queries) | |||
Threaded Mode
