From Steve Endow at Dynamics GP land comes an Excel Tip on how to Count the Number of Occurrences of a Single Character in One Cell. This can be very useful for data transformation as part of an import.
Excel Tip: Count the Number of Occurrences of a Single Character in One Cell
Tips & Hidden FeaturesExcel & Office
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.