Extracting email address out of disorganised datasheet

[kbetteley]

I have a datasheet that has become a bit garbled.
I'd like to get a way of pulling the email addresses out (and also possibly the phone numbers and other information).

I havesomething that's basically working for emails.

=IF(ISERROR(FIND("@",D17)),IF(ISERROR(FIND("@",E17)),IF(ISERROR(FIND("@",F17)),"",F17),E17),D17)

But I'd like a slightly more elegant solution if possible. One that could use a range preferably as this method requires me to write an IF clause for every column I want to search).

Thanks in advance,

Keiran

 

[pgc01]

Hi Keiran

Try:

=INDEX(D17:F17,MATCH("*@*",D17:E17,0))