Does anyone know of any Excel 2003 VBA macro code that can remove carriage returns from the text values in cells?

I foolishly thought I could have the macro do a Find and Replace, but I can't seem to get the macro to recognize a carriage return as the text to find.

Also, please do not suggest the CLEAN() function. It is not an option for me.

Thanks!

Eric

Eric G.

    Cells.Replace What:=Chr$(10), Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False

cheers

Matthew

Thanks, Matthew. That worked!

Eric

Eric G.