View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cbapt Cbapt is offline
external usenet poster
 
Posts: 1
Default I need help with removing "enters" that are separating data in a c

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