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

C

Cbapt

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
 
G

Gord Dibben

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
 
D

Dave Peterson

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

Doesn't change your reply, though.
 
G

Gord Dibben

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
 
G

Gilbert

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

Gord Dibben

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
 
Top