Jack

one way:

=(LEN(A1)-LEN(SUBSTITUTE(A1,"3a","")))/2
for a search string which is 2 characters long as in your example

Regards

Trevor


"Jack Sons" wrote in message
...
Hi all,

A certain character or group of characters appears a number of times in
the content of a cell (3a appears two times in d763ah555#3abds3j. With
what formula or code can I count that number? I think I knew it once, but
I can't remember.

Jack Sons
The Netherlands