Try this formula (say your text is in A1):
=SUBSTITUTE(SUBSTITUTE(A1,CHAR(13),""),CHAR(10),"" )
Regards,
Stefi


€žMariusz€� ezt Ã*rta:

In excel sheet I've got ceels with some words. At the end of every word i
got 2 chars: 0D0A and i want to delete them.
Please tell me how do that.
I tried everything, please help me !!! :(
May be someone have nice macro ?!