DougStroud
Well-known Member
- Joined
- Aug 16, 2005
- Messages
- 2,976
- Office Version
- 365
- Platform
- MacOS
I have a series of strings that contain colons. I would like to count the number of occurrences of the colon.
in AB10=
Accessories : Accessories : Stickers & Key Chains
Formula yields 1, but looking to return 2.
=COUNT(FIND(":",AB10))
in AB10=
Accessories : Accessories : Stickers & Key Chains
Formula yields 1, but looking to return 2.
=COUNT(FIND(":",AB10))