No, your here now.

Mine was also VBA BTW.

Try this

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

and play with CHAR(10), CHAR(160) if 13 doesn't work.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Andrew" wrote in message
...
After browsing around, I think I may have posted this in the wrong forum.
It
probably should've gone in the "Excel Worksheet Functions" forum, so I
apologize. Should I re-post this there?