Extract email address in a text

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,

Find more posts tagged with

Accepted answers

All comments

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 : )

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.