asked on Excel Formula for counting a specific character in a Cell?
I want to count how many occurrences of a certain character exist in a column of Excel data.
For example, if I want to count Ampersands (&) and I have this:
A
Cars & Trucks & Engines
Cars & Trucks
I want to end up with this
A B
Cars & Trucks & Engines 2
Cars & Trucks 1
Is there a formula (or another method) that can do this?
For example, if I want to count Ampersands (&) and I have this:
A
Cars & Trucks & Engines
Cars & Trucks
I want to end up with this
A B
Cars & Trucks & Engines 2
Cars & Trucks 1
Is there a formula (or another method) that can do this?
Microsoft ExcelMicrosoft Office
Last Comment
Subodh Tiwari (Neeraj)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Awesome, you both Rock! Thank you
You're welcome!
29166920.xlsm