| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Text to columns delimited by carriage return
I have a column where each cell has values that are separated by a carriage
return, and I want to do a Text to Column action delimited by the carriage returns. What is the best way to do this? |
|
#2
|
|||
|
|||
|
Text to columns delimited by carriage return
In the second step after choosing delimited, select other, put the cursor in
the box and hold down alt while typing 010 on the numpad, release alt -- Regards, Peo Sjoblom "EMG03" wrote in message ... I have a column where each cell has values that are separated by a carriage return, and I want to do a Text to Column action delimited by the carriage returns. What is the best way to do this? |
|
#3
|
|||
|
|||
|
Text to columns delimited by carriage return
In the "delimited by" enter ALT + 0010(from the numpad)
Alternative might be ALT + 0013 Gord Dibben Excel MVP On Mon, 31 Oct 2005 09:18:58 -0800, "EMG03" wrote: I have a column where each cell has values that are separated by a carriage return, and I want to do a Text to Column action delimited by the carriage returns. What is the best way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import comma delimited text | Excel Discussion (Misc queries) | |||
| Can I use Excel to match text data from 2 separate columns ? | Excel Worksheet Functions | |||
| how do I make hard carriage return appear in pivot table? | Excel Discussion (Misc queries) | |||
| Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
| text from one column into multiple columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
