Checking text length.

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a large list of names (about 2500) in microsoft excel but I need to
find all cells within a column that have a text length of more than 30
characters including spaces. Is there an easy way to do this or do I need to
start counting?
Thanks.
Chris.
 
Hi
one way:
- select your data (e.g. cells A1:A3000)
- goto 'format - Conditional Format)
- enter the following formula
=LEN(A1)>30
- choose a format to highlight these cells
 
I like Frank's suggestion, but I think I'd insert another column (say a new
column A) and put:

=len(b1)
and drag down

then I'd apply Data|Filter|autofilter to that column.

Then filter on greater than 30.

Those rows with long names will stay visible.
 
Back
Top