Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-30-2020, 10:01 AM
14spar15 14spar15 is offline Forumla to find all words over three characters Windows 7 64bit Forumla to find all words over three characters Office 2010 64bit
Competent Performer
Forumla to find all words over three characters
 
Join Date: Mar 2011
Posts: 100
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
 



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
Forumla to find all words over three characters VBA Find&Replace all bold, itlaic, underlined and highlighted words/characters Kalü Word VBA 22 04-24-2018 05:35 AM
Forumla to find all words over three characters How show characters instead words (status bar) BrunoChirelli Word 2 02-19-2015 12:03 PM
Forumla to find all words over three characters 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft