One quick and dirty solution, assume the words start in A2 with a header in
A1, in B2 put

=LEN(A2)<20

press enter, now select B2 again, then move the cursor with the mouse to the
lower right corner of B2 and when it changes to a thin cross double click
with the mouse to copy down the formula, now select A1 and B2 and do
datafilterautofilter, filter on TRUE in the help column. select A and B
and press F5, click special and select visible cells only, then copy and
paste somewhere else, finally remove filter (datafilter and uncheck
autofilter) then delete the help column or even the original column A
--
Regards,

Peo Sjoblom

(No private emails please)


"brazen234" wrote
in message ...

Search didn't turn up anything, so help would be appreciated.

Simple as the title sounds. I have thousands of words in column A (one
word per cell) and I would like to delete all words 20 letters or
greater.
Thanks!


--
brazen234
------------------------------------------------------------------------
brazen234's Profile:
http://www.excelforum.com/member.php...fo&userid=9952
View this thread: http://www.excelforum.com/showthread...hreadid=497103