count in cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 06 Dec 2004 17:20 GMT

Does anybody know how I can count the number of characters in a cell, I know

how to use the 'count' and 'counta' function to count the number of cells

used but not in a cell.

Thanks

Reply to this Message

Mauro Gamberini - 06 Dec 2004 17:25 GMT

=LEN(A1)

Signature

----------------------------
Mauro Gamberini

> Does anybody know how I can count the number of characters in a cell, I
> know
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Frank Kabel - 06 Dec 2004 17:29 GMT

Hi
see your other post
P.S.: please don't multipost

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Does anybody know how I can count the number of characters in a cell,
> I know
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Otto Moehrbach - 07 Dec 2004 18:45 GMT

Joe
Be aware that a space is a character to Excel. IOW, if you put "Hello"
in a cell (without the quotes), the Len formula will show 5. If you put a
space character before it or after it or within it, the Len formula will
show 6. HTH Otto

> Does anybody know how I can count the number of characters in a cell, I
> know
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message