Thread: [Solved] Forumla to find all words over three characters
View Single Post
 
Old 09-30-2020, 11:09 PM
Purfleet Purfleet is offline Windows 10 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