| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seperate Merged Cells with multiple rows?
I have cells with multiple phone numbers in there with different formats.
When I highlight the column and choose the text to columns option and select the deliminted option, there is no way to seperate the information due to a charachter sign ( a box representing the Shift+Enter function). I would like to place each seperate phone number in a different row. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort 2 or more rows of cells linked to one row of data | Excel Worksheet Functions | |||
| Getting Excel to treat merged cells as one cell when printing | Excel Discussion (Misc queries) | |||
| paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
| Rows with merged cells are not adjusting even w/ Wrap Text and au. | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
