Formula to return a certain email address

ilincach

Hello,

I have a list with several emails address. I want to have a formula to return only emails adress from the company Test (so that ends in @test.com). I avoid hard coding as not best practice. I have already my formula that can retrive only the "@test.com" part.

To resume, I just want a formula to excude everything that is not in the company TEST. Thanks

rob_marshall

@ilincach

Have you tried using Find()?

If find("test.com)>0 then item() else blank

ilincach

@rob_marshall thanks it worked as wonder!!! Cheers