Finding entries over a certain number of characters

[Brian]

Howdy All,

I have a spreadsheet with customer info on it, acct number, name, inception
date.

I am printing labels with this info and need to find the cell that contain
names with over 25 characters total (including spaces).

IE: GOODRIDGE DEVANDER ABERCROMBIE

This name contains 32 characters because there are 3 spaces between
GOODRIDGE and DEVANDER.

I would like to have a cell specify the total number of names over 25
characters as well as highlight the cells with these names.

Thanks a million,
Brian

 

[Roger Govier]

Hi Brian

Assuming the names are in column A. To find the total number of entries
longer than 25 characters
=SUMPRODUCT(--(LEN(A1:A10)>25))
To Highlight them, mark the block of cells
Format>Conditional Formatting>use dropdown to select Formula is>
=len(a1)>25
Choose format to suit your needs.

 

[Brian]

Thanks a million Roger, works great!

Hi Brian

Assuming the names are in column A. To find the total number of entries
longer than 25 characters
=SUMPRODUCT(--(LEN(A1:A10)>25))
To Highlight them, mark the block of cells
Format>Conditional Formatting>use dropdown to select Formula is>
=len(a1)>25
Choose format to suit your needs.