If you want to automatically trim the length ....
=LEFT(A1,MIN(40,LEN(A1)))

Most cool, Roger......most cool.

Vaya con Dios,
Chuck, CABGx3



"Roger Govier" wrote:

Hi Eddie

Try
=LEN(A1) to give you the number of characters in a cell

If you want to automatically trim the length of your entries, then in
another column use
=LEFT(A1,MIN(40,LEN(A1)))
and copy down

--
Regards

Roger Govier


"EddieDial800" wrote in message
...
I have several hundreds of line items that need to be entered to a web
application that restricts the length of each line to 40 characters.
Is there
a way to count the number of characters on a cell so I can automate
the
review process for each cell of my spreadsheet with one formula or
function
that indicates for each cell the number of characters (with spaces)
that it
contains?

I appreciate very much any input