Hi everyone, this is my first post in this forum and I am very pleased to know that this community exists, I found it very helpful & useful
I was wondering if there was any way in Excel to filter in a colum by the number of characters, specifically 3 letters or less.
WhatsApp Image 2022-03-26 at 7.33.37 PM.jpeg
In the column of the photo you can see many names written. I just want to filter those words that contains 3 or less characters and eliminate them without eliminating the other words. That means for example, in G1, I want to transform "A Clarinet I" into "Clarinet" by just deleting the "A" and the "I". I would need to do it in the whole column by once.
Thank you in advance
Bookmarks