Extract multiple emails from text in cell - output in same row

[juhaszp]

Hi,

I'm looking to extract emails from Column "A" which has mixed text, and output to the same column.

My spreadsheet is set up like this...

Comments/Company name/ Email 1/ Email 2/ Email 3/ Email 4/ Email 5


Here is an example of something you would find in the "comments" column.

Peggy - HMR; 573.471.3500 ; [email protected] *Ron john - ; [email protected] Lisa Penna- MIS

I have been able to exact emails but not more than one in the same row.

Thanks

SOLUTION

To remove email addresses from text. This formula can be dragged down to pull emails from other rows, or across to extract multiple emails.

Please Login or Register  to view this content.

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[juhaszp]

Apologies. It was submitted as solved and I couldn't edit it. I did however find a solution so I will post it; I forgot about this thread!

To remove email addresses from text. This formula can be dragged down to pull emails from other rows, and across to extract multiple emails.

Please Login or Register  to view this content.