View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sjs
 
Posts: n/a
Default Count Characters

I have thousands of rows in my spreadsheet and I need to identify the cells
that contain more than 30 characters. I know how to do a Validation on a
cell but that only flags me when I enter data into the formatted cell, not
when data already exists. Any ideas?

tks,
steve