NumberOfEs = Len(Text) - Len(Replace(Text, "E", ""))


CE



fallowfz wrote:
Is there a function which will return the number of times, for
example, the letter "E" appears in a cell containing a mix of text,
numbers, and other characters, e.g. (), :, etc?


Thanks!