Excel Help

[Munday]

Hi,

I need some Excel help and wondered if anyone here can help me. I have searched on Google and in the Help section and can't find how to do this.
I have a list of about 20,000 records in Excel and need to find entries in that list which are under 10 characters in length.
Thanks in advance

 

[Mells]

I think you could do this with the COUNTIF function. Look it up in the help mate.

You might need to use a couple of functions to tease out the info. =LEFT might be needed too.

 

[Munday]

Thanks Mells, I shall give it a whirl!

 

[MarkCup]

Say your entries are in column A, then in column B enter;

=LEN(A1)

This will give you a count of characters in that field (LEN is short for length).

Then sort the whole database on column B, job done.