I work with mailing lists in Excel, and sometimes I run into wrapped text
that when I unwrap it, it results in line breaks (little boxes) within cells
that were wrapped.
What I'd like to know is whether there's a way to use that line break as a
delimiter
to separate the data (i.e. two address lines) into separate columns.

Hi

Mark the column of textDataText to columnsdelimitedNextOtherthen in
the box next to other type Alt+010Finish

Ensure that the 010 is typed on the Numeric keypad, NOT the row of numbers
at the top of the keyboard.

--
Regards
Roger Govier



"separate wrapped text" <separate wrapped
wrote in message ...
I work with mailing lists in Excel, and sometimes I run into wrapped text
that when I unwrap it, it results in line breaks (little boxes) within
cells
that were wrapped.
What I'd like to know is whether there's a way to use that line break as a
delimiter
to separate the data (i.e. two address lines) into separate columns.

CTRL + j also works to enter the linefeed character.


Gord Dibben MS Excel MVP

On Sat, 3 Nov 2007 11:27:02 -0000, "Roger Govier"
<rogerattechnology4NOSPAMu.co.uk wrote:

Hi

Mark the column of textDataText to columnsdelimitedNextOtherthen in
the box next to other type Alt+010Finish

Ensure that the 010 is typed on the Numeric keypad, NOT the row of numbers
at the top of the keyboard.