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