Hi Chris,

Thanks for the help...I simply need to identify fields that exceed 30
characters then I need to shorten them appropriately, the fields are product
descriptions that I'll import into a business system. The "LEN" command to
id the cells works like a champ!

Have a great weekend!

steve

"Chris Lavender" wrote:

Hi Steve

You can use an IF function on another sheet eg =IF(LEN(Sheet1!A1)30,1,"")
and then use that data somehow. You don't say what you want to do with your
cells containing more than 30 characters. If you want to convert them all
to 30 characters max, then you can enter a formula on Sheet2, eg
=LEFT(Sheet1!A1,30), copy it down and across and then convert it all to
values....

HTH
Best rgds
Chris Lav



"sjs" wrote in message
...
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