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