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

- URL: https://dynamicaccounting.net/excel-tip-count-the-number-of-occurrences-of-a-single-character-in-one-cell/
- Date: 2010-10-19
- Topics: Tips & Hidden Features, Excel & Office
- Type: link to an external article
- Source: http://dynamicsgpland.blogspot.com/

From Steve Endow at [Dynamics GP land](http://dynamicsgpland.blogspot.com/) comes an  [Excel Tip on how to Count the Number of Occurrences of a Single Character in One Cell](http://dynamicsgpland.blogspot.com/2010/10/excel-tip-count-number-of-occurrences.html). This can be very useful for data transformation as part of an import.