count number of letters in a string

=LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))

with the string in A1

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Wiley" <[email protected]> wrote in message
news:[email protected]...
> How do I count the number of letters in a string? For example, the number
> "W" in this string "WWWEEERRRWWDDR" is 5.

Try this:

With A1 containing WWWEEERRRWWDDR

B1: =LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Wiley" wrote:

> How do I count the number of letters in a string? For example, the number
> "W" in this string "WWWEEERRRWWDDR" is 5.

=LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Wiley" <[email protected]> wrote in message
news:[email protected]...
> How do I count the number of letters in a string? For example, the number
> "W" in this string "WWWEEERRRWWDDR" is 5.

How do I count the number of letters in a string? For example, the number
"W" in this string "WWWEEERRRWWDDR" is 5.

=LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))

with the string in A1

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Wiley" <[email protected]> wrote in message
news:[email protected]...
> How do I count the number of letters in a string? For example, the number
> "W" in this string "WWWEEERRRWWDDR" is 5.

Try this:

With A1 containing WWWEEERRRWWDDR

B1: =LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Wiley" wrote:

> How do I count the number of letters in a string? For example, the number
> "W" in this string "WWWEEERRRWWDDR" is 5.

=LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Wiley" <[email protected]> wrote in message
news:[email protected]...
> How do I count the number of letters in a string? For example, the number
> "W" in this string "WWWEEERRRWWDDR" is 5.