Replace a ; with a , and a space
 

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 , etc

Hope you can help!!

Thanks in advance

Jo

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

"Jo" wrote:

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 , etc

Hope you can help!!

Thanks in advance

Jo