Using Find or search for Cells with <3 Characters?
 

I have an excel spreadsheet with thousands of entries in it down just
one column "A". My question is, how do I find just the cells with less
than 3 or 4 characters in them and with or without numbers also? Is
this possible?

Thanks for your help!!

Using Find or search for Cells with <3 Characters?
 

Paste this function in column B and copy down
=IF(LEN(A1)<3,"less","more")
it will tell you if it has less than 3
Or a better way is just to do a =Len(A1) and copy that down then copy paste
special values and sort.

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"MichiganMan" wrote in message
ups.com...
I have an excel spreadsheet with thousands of entries in it down just
one column "A". My question is, how do I find just the cells with less
than 3 or 4 characters in them and with or without numbers also? Is
this possible?

Thanks for your help!!