Formula to count length of text in a column

[davidb]

I have Office XP and need to create a formula that will identify th
cells in a column of about 20k lines that have 12 characters of text o
more in each cell. I would really appreciate some help with this as i
would allow me to help somone else with a different problem

 

[JulieD]

Hi David

one way

select the column, choose format / conditional formatting
choose
formula is
in the white box type (this assumes your data is in column A, change to
suit)
=len(A1)>11
click on the format button
set the colour to red or whatever
click Ok
Ok

and all the cells in the column that have 12 or more characters will now be
shown in red.

Another way

in the blank column next to the column you are testing for
type (this assumes your data is in column A, change to suit)
=IF(LEN(A1)>11,"YEP","")
double click on the fill handle to fill down, now all the cells with 12 or
more characters will have the word YEP next to them.

Hope this helps

JulieD

 

[davidb]

Thanks Julie, I was sure it would be simple and I just couldn't see it
You helped me save a subordinates job and I appreciate it!

Davi