![]() |
|
#1
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to find (highlight) two and more words in a list of 75k single words in Word 2010 | Usora | Word | 8 | 05-29-2018 03:34 AM |
VBA Find&Replace all bold, itlaic, underlined and highlighted words/characters
|
Kalü | Word VBA | 22 | 04-24-2018 05:35 AM |
How show characters instead words (status bar)
|
BrunoChirelli | Word | 2 | 02-19-2015 12:03 PM |
Color words ending with special characters
|
Singh_Edm | Word | 2 | 01-20-2014 12:51 AM |
| Can you check the "find whole words only" box when using characters? | pimpong | Word | 6 | 02-06-2012 06:56 PM |