Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Splitting text divided by carriage returns
1,039 views
Skip to first unread message
Phil H
Nov 27, 2009, 5:12:01 AM11/27/09
to
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).
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?
Billy Liddel
Nov 27, 2009, 5:32:01 AM11/27/09
to
Use the sequence ALT + 010 in the other delimiter box. Use the Number pad to
enter the numbers
enter the numbers
HTH
Peter
Rick Rothstein
Nov 28, 2009, 3:18:05 PM11/28/09
to
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.
"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" <Billy...@discussions.microsoft.com> wrote in message
news:C31CB3DC-0AFA-432F...@microsoft.com...
0 new messages