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