delete carriage returns from fields in column

Hi,

I was hoping someone could point me in the right direction(s).
I have a column in my spreadsheet that contains "notes". I need to remove all the carriage returns from each note.

Any help would be greatly appreciated.

Thank you much in advance, Case

Using a formula,

=SUBSTITUTE(A1, CHAR(13), "")

Thanks VBA Noob,

This worked liked a charm!!

Case

Originally Posted by VBA Noob

Try this code.

Links shows you were to put code

http://www.contextures.on.ca/xlvba01.html#Regular

Then select the column or range and press Alt + F8 and select clean up from the list

Please Login or Register  to view this content.

VBA Noob