Hi Mark,

in say A2
= Clean(A1)
copy across, then copy row 2 and paste special values

Regards,
Peter T




"mvyvoda" wrote in message
...
I have a sheet that in Row 1 has text. Within that text, there is also a
character/s (maybe carriage return, not sure) that is messing everything
up.

I need a way to automate (e.g. macro) that row only having "valid
characters." i'm not sure if i would use an ascii chart or what to weed
them
out. i can only have characters 32 - 126, in an ascii chart. I can send
the
sheet in question.

thanks,
mark