Extract email address in a text

Wethepeople

Hi,

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

julie@outlook.fr

Urgent order"

Thanks a lot for your help,

Eric Law

Hello @Wethepeople, here is a post that outlines what you need.

https://community.smartsheet.com/discussion/81485/formula-to-extract-an-email-from-a-text-string-cell

Basically you LEFT and RIGHT Join.

Wethepeople

Thanks a lot : )