View Single Post
 
Old 09-30-2020, 10:01 AM
14spar15 14spar15 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default Forumla to find all words over three characters

Hello, I need a formula to give me all of the words (contains letters only - no numbers) in a cell that have over three letters. If possible I only want these words that are after the last “-“ in this cell. If not, I can first just trim the string after the last “-“ but I would like to see how the two could be combined. For example “lizard squirrel - bird - mouse dog cat skunk23 alligator“ would return “mouse alligator “. I’ve been looking all morning and can’t find anything close enough to figure this out. Thank you
Reply With Quote