Replace a ; with a , and a space

J

Jo

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 [email protected], [email protected] etc

Hope you can help!!

Thanks in advance

Jo
 
S

SpudHutton

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