Posted to microsoft.public.excel.misc

Eric

external usenet poster

Posts: 1,670

How to count the match letter within a string?

Does anyone have any suggestions on how to count the match letter within
string?
such as "RRRRR" in cell A1, then return the number of "R" in cell B1, which
is 5.
Does anyone have any suggestions?
Eric

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
letter number count	Alicia	Excel Worksheet Functions	11	May 25th 07 12:21 AM
I WANT TO COUNT HOW MANY TIMES A CERTAIN LETTER APPEARS IN A ROW	spring022377	Excel Worksheet Functions	13	February 16th 07 08:39 AM
How can I count the number of times a letter repeats in a string?	Wiley	Excel Worksheet Functions	3	May 11th 06 06:53 PM
count a number range and a letter in a cell	santaviga	Excel Worksheet Functions	3	April 28th 06 11:11 AM
count cells in a coloumn with letter x in it	sarg	Excel Worksheet Functions	2	September 24th 05 09:01 PM

All times are GMT +1. The time now is 05:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us