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



"Gats" wrote in message
...
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.