count number of letters in a string
How do I count the number of letters in a string? For example, the number
"W" in this string "WWWEEERRRWWDDR" is 5. |
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" wrote in message ... How do I count the number of letters in a string? For example, the number "W" in this string "WWWEEERRRWWDDR" is 5. |
count number of letters in a string
=LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "Wiley" wrote in message ... How do I count the number of letters in a string? For example, the number "W" in this string "WWWEEERRRWWDDR" is 5. |
count number of letters in a string
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. |
All times are GMT +1. The time now is 08:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com