extract from string whole word(s) containing substring

**Bearpecs** · 09-23-2012, 11:55 AM

if a cell contains a string "Quarterly Reports for 2012", and I need words containing "por", what formula will return "Reports"?

if a cell contains a string "Gone Fishing and not coming back", and I need all words containing "ing", what formula will return "Fishing; coming"?

thanks very much.

**mike7952** · 09-23-2012, 12:32 PM

I think you will need a UDF.

Formula:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**Bearpecs** · 09-23-2012, 12:47 PM

thanks very much!
that works to find the first word in the string. can it be tweaked to provide all words in the string?

**mike7952** · 09-23-2012, 12:53 PM

For me in cell A1 Gone Fishing and not coming back

Formula:

Please Login or Register  to view this content.

Returns Fishing coming.

**Bearpecs** · 09-24-2012, 10:37 AM

thank you!

extract from string whole word(s) containing substring

LinkBack

Thread Tools

Rate This Thread

Display

extract from string whole word(s) containing substring

Re: extract from string whole word(s) containing substring

Re: extract from string whole word(s) containing substring

Re: extract from string whole word(s) containing substring

Re: extract from string whole word(s) containing substring

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions