Seperate Merged Cells with multiple rows?

G

Gats

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.
 
P

Peo Sjoblom

You mean alt + enter, if so select other and click in the other box in step
2 of text to columns,
hold down alt while typing 010 on the numpad, release alt and click finish

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Top