RE: Counting Texts

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try this spreadsheet formula:

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

since SUBSTITUTE is case sensitive you can modify this to read

=LEN(A1)-LEN(SUBSTITUTE(LOWER(A1),"w",""))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Keith" wrote:

If cell A1 contains a paragraph of texts and if I want to count just letter
"W"s (Upper or lower case), How can I achieve this?

Example: A1 contains "How now brown cow" the formula should return "4".

Thank you.


.

Relevant Pages

  • RE: Counting Texts
    ... "Shane Devenshire" wrote: ... since SUBSTITUTE is case sensitive you can modify this to read ... "W"s (Upper or lower case), ...
    (microsoft.public.excel)
  • Re: Looking for a macro or formula to use in excel.
    ... Or you could modify the formula that does the conversion: ... "Keith G" wrote: ... Keith (Southend) ... My problem is when there was no rainfall and no entry because of this, ...
    (microsoft.public.excel)
  • Re: Okay, Kris.....
    ... >> At least his substitute is very good (better than the serious blonde woman ... Keith certainly gets a lot of vacation days. ...
    (alt.true-crime)
  • Re: Copy exploded view from one assembly to another?
    ... might successfully re-attach the explode data (analagous to mates). ... exploded view and then modify or substitute some of the parts. ...
    (comp.cad.solidworks)
  • Re: User security advice
    ... Thanks Keith, I'll have a look on your site and walk through your ... without ever having the option to modify it in any way, ... When it comes to security, I'd like to run it by an expert. ... If you're using the mdb file format then you can use the built-in user-level ...
    (microsoft.public.access.security)