| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trouble splitting cell contents
And to specify that alt-enter character, select the Other box, remove anything
that's in that box and hit ctrl-j. Gary''s Student wrote: Use the Text-to-Columns feature with ALT-ENTER as the separator character -- Gary''s Student - gsnu200715 "scottr" wrote: Any help would be greatly appreciated. I have a file that was imported from our house ADP program. Some cells were brought in with 3 lines of info in 1 cell. 453 453 1 This previous info was all in cell b1. What is the easiest way to split this information so I can pull information from here to another spreadsheet? Thanks again for help -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print excel spreadsheet splitting cell contents on multiple pages | Excel Discussion (Misc queries) | |||
| Splitting the contents of a cell | Excel Discussion (Misc queries) | |||
| Splitting the contents of a cell? | Excel Worksheet Functions | |||
| Splitting Cell Contents with a comma | Excel Worksheet Functions | |||
| Splitting multiple cell contents containing values at end | Excel Worksheet Functions | |||
Threaded Mode
