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:
Cars & Trucks & Engines
Cars & Trucks
I want to end up with this
Cars & Trucks & Engines 2
Cars & Trucks 1
Is there a formula (or another method) that can do this?