Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 09-30-2020, 11:09 PM
Purfleet Purfleet is offline Forumla to find all words over three characters Windows 10 Forumla to find all words over three characters Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

paste the text in to column A - 1 row for each peice of text, then select however many you want to split and hit the button.

Each word over 3 charecters with no numbers will then appear in the columns to the right

I have deleted the output and reattached - to test it just select A1 to A16 and click the button

Last edited by Purfleet; 09-30-2020 at 11:10 PM. Reason: typo
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 05:53 PM.


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