troubleshooting Question

Excel Formula for counting a specific character in a Cell?

Avatar of bleggee
bleggeeFlag for United States of America asked on
Microsoft ExcelMicrosoft Office
4 Comments1 Solution93 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros