count digits within cell
 

I want to create a forumula in B1 that will sum up how many letters I have
entered into A1. There will never be more than five digits in A1. I frankly
don't know where to begin.

example: A1 = MTW
--
Thanks for being here

Try:
=len(a1)

"apostate2" wrote:

I want to create a forumula in B1 that will sum up how many letters I have
entered into A1. There will never be more than five digits in A1. I frankly
don't know where to begin.

example: A1 = MTW
--
Thanks for being here

Thanks!

"Gary's Student" wrote:

Try:
=len(a1)

"apostate2" wrote:

I want to create a forumula in B1 that will sum up how many letters I have
entered into A1. There will never be more than five digits in A1. I frankly
don't know where to begin.

example: A1 = MTW
--
Thanks for being here

Hi
You may also try LEN(TRIM(A1)) which will count the characters without any
trailing spaces that may have been inadvertantly left in the cell.

--
Andy.


"Gary's Student" wrote in message
...
Try:
=len(a1)

"apostate2" wrote:

I want to create a forumula in B1 that will sum up how many letters I
have
entered into A1. There will never be more than five digits in A1. I
frankly
don't know where to begin.

example: A1 = MTW
--
Thanks for being here

=trim() also cleans up leading/trailing and multiple internal spaces, too.



"Andy B" wrote:

Hi
You may also try LEN(TRIM(A1)) which will count the characters without any
trailing spaces that may have been inadvertantly left in the cell.

--
Andy.

"Gary's Student" wrote in message
...
Try:
=len(a1)

"apostate2" wrote:

I want to create a forumula in B1 that will sum up how many letters I
have
entered into A1. There will never be more than five digits in A1. I
frankly
don't know where to begin.

example: A1 = MTW
--
Thanks for being here

--

Dave Peterson