Hi Rick

Put it down to a senior moment!!!
For some stupid reason, I was thinking that left(a1,40) was going to pad
the value with extra spaces.
Guess I managed to fool Chuck for a few moments (he must have been
sharing that moment with me)<vbg

Apologies to all
=LEFT(A1,40) wins the day.
--
Regards

Roger Govier


"RagDyeR" wrote in message
...
OK, I give up!

What's the advantage over plain 'ol:
=Left(a1,40)
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

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