I need help with removing "enters" that are separating data in a c

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cbapt - 06 Jun 2007 21:25 GMT

I have data that has been downloaded from a tool and sometimes comments are
listed in one cell wiht the "Enter Arrow" in between the items which cause
issues. Is there an way to remove the arrows in the column of data?

Example :
*test
*test2
*test 3

I hit the enter key after each line, but in excel it keeps all 3 lines in
one cell

Reply to this Message

Gord Dibben - 06 Jun 2007 22:08 GMT

If these are carriage returns you should be able to remove them using Data>Text
to Columns.

Select the cells...make sure you have some blank collumns to right of
cells........then Data>Text to Columns>Delimited by>Other hit CTRL + j and Next.

Are the cells broken up?

If so hit Finish.

Gord Dibben MS Excel MVP

>I have data that has been downloaded from a tool and sometimes comments are
>listed in one cell wiht the "Enter Arrow" in between the items which cause
[quoted text clipped - 7 lines]
>I hit the enter key after each line, but in excel it keeps all 3 lines in
>one cell

Reply to this Message

Dave Peterson - 06 Jun 2007 22:39 GMT

I think the CRs would be alt-0013 and the LFs are alt-0010 (or ctrl-j).

Doesn't change your reply, though.

> If these are carriage returns you should be able to remove them using Data>Text
> to Columns.
[quoted text clipped - 19 lines]
> >I hit the enter key after each line, but in excel it keeps all 3 lines in
> >one cell

Signature

Dave Peterson

Reply to this Message

Gord Dibben - 06 Jun 2007 23:24 GMT

CR is my generic term for anything that resembles a line feed or whatever.

Maybe they should be hard returns and soft returns?

It's all too confusing anymore.

Gord

>I think the CRs would be alt-0013 and the LFs are alt-0010 (or ctrl-j).
>
[quoted text clipped - 23 lines]
>> >I hit the enter key after each line, but in excel it keeps all 3 lines in
>> >one cell

Reply to this Message

Gilbert - 15 Jun 2007 21:21 GMT

Thanks for this. I was also looking for the same thing. I do have a
question, what are CRs and LFs?

> CR is my generic term for anything that resembles a line feed or whatever.
>
[quoted text clipped - 31 lines]
> >> >I hit the enter key after each line, but in excel it keeps all 3 lines in
> >> >one cell

Reply to this Message

Gord Dibben - 16 Jun 2007 01:43 GMT

CR......Carriage Return

LF.......Line Feed

Using Alt + Enter you can place linefeeds into a cell.

As noted by Dave, these are not technically carriage returns but anything that
returns the cursor or carriage to left side of the next line can be called a
carriage return IMO

Gord

>Thanks for this. I was also looking for the same thing. I do have a
>question, what are CRs and LFs?
[quoted text clipped - 34 lines]
>> >> >I hit the enter key after each line, but in excel it keeps all 3 lines in
>> >> >one cell

Reply to this Message