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