How do I count the number of times a particular charcter ("." say)

Posts: n/a

How do I count the number of times a particular charcter ("." say)

How do I count the number of times a particular charcter ("." say) appears in
a cell.

For example, ABC.1.21.31.2 should retun 4.

Is there a formula?

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
Count number of occurences in 1 column only if something in anothe	Wenster	Excel Worksheet Functions	2	February 7th 05 09:58 PM
How do I count the times a number occurs in a given criteria?	w_aller	Excel Discussion (Misc queries)	2	February 3rd 05 09:06 AM
Count number to reach a cumulative value	Bruce	Excel Worksheet Functions	5	January 25th 05 05:14 PM
Count number of shaded cells	Maddoktor	Excel Discussion (Misc queries)	2	December 20th 04 08:35 PM
Whats the function to count the total times a word is displayed	Monk	Excel Discussion (Misc queries)	3	December 10th 04 10:39 PM

All times are GMT +1. The time now is 09:06 PM.

Menu

About Us