how to isolate email address from long line of info?

[robgoldstein]

I have exported some information and now I need to extract just the email that in the middle of that long line of informatoin and the length of that information changes. Is there a way I can do this?
Here is an example of my information

Phone: 403.875.0125Email: info@corrinawalker.com Address: Calgary, AlbertaWebsite: http://corrinawalker.comCorrina Walker Photography is driven to stay current and informed of the constant developments and trends in the industry. Our photographic style is inspired from influences in fashion, photojournalism, fine art, and travel. We have been shooting professionally in Alberta, British Columbia, Saskatchewan and internationally for over ten years. Please check out our website Calgary Wedding Photographer | Calgary Photography | Corrina Walker Photography for more information.

<tbody>
</tbody>

 

[NeonRedSharpie]

=MID(O7,FIND("Email:",O7)+6,FIND(" ",O7,FIND("Email:",O7))-FIND("Email:",O7)-6)

Be careful...

The " " is not a space. It's an html character. You'll have to copy the html character from a string the first time.

 

[robgoldstein]

thanks so much. Will this work with different length email addresses?

 

[NeonRedSharpie]

Yup. It assumes there is the "Email:" in front and that weird HTML character after it. It finds the start, the end, and then pulls what's inbetween.

 

[robgoldstein]

awesome, thanks so much

 

[kaykrazy]

I am trying to isolate the part of a field after the first dash.

abc123-prod
abc123-prod-m
abc1234-prod-d-wm

I tried using your email solution and I can get it to work if I use a different character for subsequent dashes after the first one.

 

[NeonRedSharpie]

I am trying to isolate the part of a field after the first dash.

abc123-prod
abc123-prod-m
abc1234-prod-d-wm

I tried using your email solution and I can get it to work if I use a different character for subsequent dashes after the first one.

Are you planning to return EVERYTHING after the first dash no matter what? What is your full cell value and then your expected return?