ExcelBanter - Count number times text appears in string

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count number times text appears in string (https://www.excelbanter.com/excel-discussion-misc-queries/263144-count-number-times-text-appears-string.html)

Count number times text appears in string

A
1 Module: C126, Module: C130, Module: C138, Module: C105

Can any help me write a function that would return the count of a specified
text in a cell.

For example for the string in cell A1 I would like to know how many times
does the text 'Module' appear.

All times are GMT +1. The time now is 06:41 PM.