Text-to-Column with Paragraph Delimiter

[AL]

Hi all --

I have an Excel sheet where one column has entries on two lines in the
single cell (separated by a paragraph mark). I want to split the
column into two using the paragraph mark as the delimiter -- but I
haven't been able to do this successfully. Is it possible and, if so,
how do I go about it?

Many thanks,

AL

 

[RagDyeR]

Don't exactly know what you mean by a "paragraph mark",
but if you used Char(10) (<Alt> <Enter),
try this is TTC:

Use "Delimited" and in the second step of the wizard,
click on "other" and enter
<Ctrl> <J>
(Of course, you realize that nothing will be visible in the box.)

Then <Finish>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi all --

I have an Excel sheet where one column has entries on two lines in the
single cell (separated by a paragraph mark). I want to split the
column into two using the paragraph mark as the delimiter -- but I
haven't been able to do this successfully. Is it possible and, if so,
how do I go about it?

Many thanks,

AL