This replaced the double vertical line with a single one. Any way to remove
the single one?

Thanks a bunch for your help!!

"Roger Govier" wrote:

Hi Diane

Try
=SUBSTITUTE(A1,CHAR(10),", ")

--
Regards
Roger Govier

"rroswell86" wrote in message
...
I exported outlook information into excel. Where there was a return in
the
address, I get two thick vertical bars, which operate like a return when
mail
merged to Word.

I want to replace the return with a comma and a space. Is this possible?

Thanks for your help!

Diane