bleggee

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:

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 thisCars & Trucks & Engines

Cars & Trucks

**A B**

Cars & Trucks & Engines 2

Cars & Trucks 1

Cars & Trucks & Engines 2

Cars & Trucks 1

Is there a formula (or another method) that can do this?

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Awesome, you both Rock! Thank you

You're welcome!

29166920.xlsm