Formula to return a certain email address



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 I avoid hard coding as not best practice. I have already my formula that can retrive only the "" part.

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

Best Answer