IS THIS POSSIBLE? NUMBER OF LETTERS IN A CELL???

  • Thread starter Thread starter HERNAN
  • Start date Start date
H

HERNAN

I would like to count the number of digits into a cell, for example:
Cell A1 = 33541 the result I am looking for is 5, because there are 5
numbers inside that cell.

Or the number of letter in a word, for example, cell A2 = "CAR" so the
answer would be 3, (C - A - R )

Is this possible?
Thanks
 
I would like to count the number of digits into a cell, for example:
Cell A1 = 33541  the result I am looking for is 5, because there are 5
numbers inside that cell.

Or the number of letter in a word, for example, cell A2 = "CAR" so the
answer would be 3, (C - A - R )

Is this possible?
Thanks

LEN(A2) = 3
Jay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top