Splitting text divided by carriage returns

P

Phil H

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?
 
B

Billy Liddel

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

HTH
Peter
 
R

Rick Rothstein

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top