If these are carriage returns you should be able to remove them using DataText
to Columns.

Select the cells...make sure you have some blank collumns to right of
cells........then DataText to ColumnsDelimited byOther hit CTRL + j and Next.

Are the cells broken up?

If so hit Finish.


Gord Dibben MS Excel MVP

On Wed, 6 Jun 2007 13:25:01 -0700, Cbapt
wrote:

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