Is there a formula that will count the number of times a character or word appears in a cell? I have downloaded fields from a database where each item is separated by the word "and". For example the field would say Atlanta_and_Chicago_and_Detroit. I am trying to count the number of cities that show up in this field so in this example I would want it to return 3. Is there a simple formula to count the number of "and"s in a cell?

Thanks in advance