Need a formula to count values in a cell, separated by multiple characters

Hello all,

I've been trying to figure out a formula to count the amount of values in a specific cell. Some cells contain values separated by commas, some contain values separated by "/", some with "-" and some with a combination of all of the above

Can someone please help me figure out a formula that will spit out how many values are in a cell separated by either of these characters/combination of these characters?

For example, the attached spreadsheet has 10 different values in cell A5, separated by different symbols. What is a formula that will tell me there is 10 values in that cell

Any help would be greatly appreciated.

Thanks!

Did you upload the correct workbook?
None of the data looks like it contains delimited values.

Using your posted workbook...try something like this:

Please Login or Register  to view this content.

Is that something you can work with?