Hi all,
I need to delete from a cell all the words shorter than N characters, leaving only the words equal or longer than N characters.
Example
Given: Cell contains "The brown bear ran quickly up the hillside"
Desired result if N=3: "brown bear quickly hillside"
Words are always separated with a single space.
I'd prefer a formula. A leading and trailing space can be added if that will simplify things much.
Thanks in advance for any help!
Bookmarks