19 October 2010

Excel Tip: Count the Number of Occurrences of a Single Character in One Cell

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.