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.
Bookmarks