| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unicode text and carriage returns | Excel Discussion (Misc queries) | |||
| Importing Text with Carriage Returns inside cell values | Excel Discussion (Misc queries) | |||
| Can I insert 'carriage/line returns' in text string? | Excel Worksheet Functions | |||
| How can I enter carriage returns into text within a cell in excel | Excel Discussion (Misc queries) | |||
| How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) | |||
![Phil H[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
