Remove 0D0A from cell with word
 

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 ?!

Remove 0D0A from cell with word
 

Sub ReplaceStuff()

Selection.Replace _
What:=vbCrLf, _
Replacement:="", _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False
End Sub

--
Regards,
Tom Ogilvy


"Mariusz" wrote:

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 ?!

Remove 0D0A from cell with word
 

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 ?!