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?

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" <EMG03@discussions.microsoft.com> wrote in message
news:5D3CC1F8-2E43-42DE-AACF-7C5CA1D3525A@microsoft.com...
> 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?

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" <EMG03@discussions.microsoft.com>
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?