How to use "Find and Replace" to edit a long list of 100's of emails?

[JohnDohe]

Hi,

I've got a long list of 100's of emails formatted like this:
John, (e-mail address removed),

But the "John, Doe." preceeding the actual email
address is being read as an incomplete email
address when I use this list to Bcc my friends
so I'm happy to just delete "John, Doe." and be
left with just the email addresses in my list.

I want to end up with just this:
(e-mail address removed),

I need to delete the,
* first name,
* the comma "," after the first name,
* the last name,
* the period '.' after the last name
to be left with just the email address.

I've tried to figure out how to use "Word for Mac 2019's"
wildcards to search and replace, but I cannot figure out
how to properly format the search term in the "Find what"
field of the "Advanced Find and Replace" function.

Does anyone know the proper way to do this so I can
run the "Find and Replace" to remove all but the
email address in my list of hundred's of names+emails?

Thanks!

 

[Cory Cooper]

Hello,

This is currently in a Word document, correct? I wonder if you would be able to open it in Excel and have it split the name and addresses into separate columns?

C