Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the char "w"?
Does anyone have any suggestions on how to count the char "w" within cell A1?
For example, in cell A1, waterfall - wc, please ignore the upper / lower case, I would like to count how many "w" or "W" inside the cell A1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the char "w"?
Try =LEN(A1)-LEN(SUBSTITUTE(A1,"w",""))
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Eric" wrote in message ... Does anyone have any suggestions on how to count the char "w" within cell A1? For example, in cell A1, waterfall - wc, please ignore the upper / lower case, I would like to count how many "w" or "W" inside the cell A1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the char "w"?
Try:
=LEN(F7)-LEN(SUBSTITUTE(LOWER(F7),"w","")) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Eric" wrote in message ... Does anyone have any suggestions on how to count the char "w" within cell A1? For example, in cell A1, waterfall - wc, please ignore the upper / lower case, I would like to count how many "w" or "W" inside the cell A1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the char "w"?
"Bernard Liengme" wrote in message
... Try =LEN(A1)-LEN(SUBSTITUTE(A1,"w","")) Bernard, Doesn't fine upper case W -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the char "w"?
Try this...
=LEN(A1)-LEN(SUBSTITUTE(LOWER(A1),"w","")) Rick "Eric" wrote in message ... Does anyone have any suggestions on how to count the char "w" within cell A1? For example, in cell A1, waterfall - wc, please ignore the upper / lower case, I would like to count how many "w" or "W" inside the cell A1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the char "w"?
Hi Eric,
Take the length of the original and subtract the length with the "W" removed., add same for the lowercase, since SUBSTITUTE is case-sensitive. =(LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))) + (LEN(A1)-LEN(SUBSTITUTE(A1,"w",""))) or =LEN(A1)-LEN(SUBSTITUE(UPPER(A1),"W")) More of the same type of things on my strings page http://www.mvps.org/dmcritchie/excel/strings.htm -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Eric" wrote in message ... Does anyone have any suggestions on how to count the char "w" within cell A1? For example, in cell A1, waterfall - wc, please ignore the upper / lower case, I would like to count how many "w" or "W" inside the cell A1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the char "w"?
Thanks everyone for suggestions
Eric "Bernard Liengme" wrote: Try =LEN(A1)-LEN(SUBSTITUTE(A1,"w","")) best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Eric" wrote in message ... Does anyone have any suggestions on how to count the char "w" within cell A1? For example, in cell A1, waterfall - wc, please ignore the upper / lower case, I would like to count how many "w" or "W" inside the cell A1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
How to perform Search and Replace on "Tilde", CHAR(126), ~ | Excel Worksheet Functions | |||
How to delete the char "A" if it exists? | Excel Discussion (Misc queries) | |||
Count(if(A3:A200)="100000" if (B3:B200="Y") and (C3:C200=Z))) | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |