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?

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?

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?