Extract Email Addresses

I have a single cell that has names mixed with email addresses. LOTS of names and email addresses all in one cell.

Example: A1= [email protected],joe smith [email protected],Sally Jones ...

Need a column with ONLY email address for everyone in that original cell.

Thanks for your help.

Hi,

assumption: the mail address is separated from other text by a space " " or a comma ",": Mail.xlsm

Regards

Try the example file from post #2.

Regards

for all in one cell (A1) try this one:

Please Login or Register  to view this content.