Replace a ; with a , and a space

[Guest]

Hi

I have a distribution list that has been pasted into a cell in Excel. The
email address are separated by a semi colon.

Is there a way to globally replace the semi colon with a comma (,) and a
space?

eg (e-mail address removed), (e-mail address removed) etc

Hope you can help!!

Thanks in advance

Jo

 

[Guest]

Yes. Replace is Ctrl+H. Don't type the "quotes" below.
Find: ";"
Replace with: ", "
HTH. SpudHutton