Extract email address in a text



I would like to extract an email address in a text, knowing that the email address could be in at the beggining of the text, in the midldle of the text, at the end. I have tried formulas with MID, to extract what's before and after the character "@" but I can't find a way to do it on smartsheet, without TRIM ou REPT.

For instance I have this text in a cell and I want to extract the email address (julie@outlook.fr)

"Adresse : 8 rue de cambrai


Urgent order"

Thanks a lot for your help,


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!