EXCEL - Count characters in cell

[herrld]

I need to find all cells (in 1 column) that have more or less than 12 characters. If the column contains exactly 12 characters than I don't want to see it.
Can someone help please. Linda

 

[mikevh]

In another column, assuming your data is in col A,
enter the formula
=NOT(LEN(A1)=12)

This will return TRUE for the cells you want to see

You can put an autofilter on the column that contains
this formula and say you only want to see cells
where it is TRUE. The cells with 12 chars will be
hidden.

 

[herrld]

Thank you very much!! Linda

 

[Cresby]

or use conditional formatting (no need for a boolean column then) to render the text colour the same as the background. I use this a lot because having non-contiguous rows plays havock with the mindset of what you are dealing with. Well it does for me.