| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells
Hello,
I have a lot of columns and a lot of rows in 1 spreadsheet. In one of the columns, there are a lot of cells within that column which contain multiple pieces of data separated by "ALT-ENTER" within each cell. Does anyone know how to split out the content within these cell into multiple rows/cells (again, the content is currently separated by "ALT- ENTER")? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| Cond Format & helper-cell based "duplicate rec" tricked by content | Excel Discussion (Misc queries) | |||
Threaded Mode
