Splitting text divided by carriage returns
 

I have a report in which multiple responses are provided in a single cell.
The responses appear on different lines as if these had been added with a
carriage return (i.e. as entered using ALT and RETURN).

I know that you can normally split cell contents into columns using the
Convert Text to Columns Wizard under DATA / TEXT TO COLUMNS and then
Delimited, however I don't know what the character or feature would be for
soft carriage returns.

Any ideas on this or an alternate methodology?

Splitting text divided by carriage returns
 

Use the sequence ALT + 010 in the other delimiter box. Use the Number pad to
enter the numbers

HTH
Peter

"Phil H" wrote:

I have a report in which multiple responses are provided in a single cell.
The responses appear on different lines as if these had been added with a
carriage return (i.e. as entered using ALT and RETURN).

I know that you can normally split cell contents into columns using the
Convert Text to Columns Wizard under DATA / TEXT TO COLUMNS and then
Delimited, however I don't know what the character or feature would be for
soft carriage returns.

Any ideas on this or an alternate methodology?

Splitting text divided by carriage returns
 

You can also key in Ctrl+J and it will work also... nothing will show in the
"Other" field, but if you look at the table at the bottom of the dialog box,
you will see the text has been split into columns.

--
Rick (MVP - Excel)


"Billy Liddel" wrote in message
...
Use the sequence ALT + 010 in the other delimiter box. Use the Number pad
to
enter the numbers

HTH
Peter

"Phil H" wrote:

I have a report in which multiple responses are provided in a single
cell.
The responses appear on different lines as if these had been added with a
carriage return (i.e. as entered using ALT and RETURN).

I know that you can normally split cell contents into columns using the
Convert Text to Columns Wizard under DATA / TEXT TO COLUMNS and then
Delimited, however I don't know what the character or feature would be
for
soft carriage returns.

Any ideas on this or an alternate methodology?