You're welcome. Thanks for the feedback. Glad we got to the solution for
you.


"Jack Sons" wrote in message
...
Trevor, Dave,

"Still uses SUBSTITUTE though. You don't actually change the original
value if that is your concern."

Indeed, that was the point of my question, I now realize that substitute
does not change the the string.

Thanks a lot.

Jack.

"Trevor Shuttleworth" schreef in bericht
...
Why ? What is it you need to achieve ? Surely, all you need is the
answer to the question ?

=(LEN(A1)-LEN(SUBSTITUTE(A1,B1,"")))/(LEN(B1))

A1 = d763ah555#3abds3j
B1 = 3a
C1 = 2 (the formula shown above)

Assumes the full string is in cell A1 and what you are looking for is in
cell B1. Still uses SUBSTITUTE though. You don't actually change the
original value if that is your concern.

Do you have some idea of the formula you want and you need help in making
it work ?

Regards

Trevor


"Yvonne_G" wrote in message
...
Trevor, TK and Dave,

Thank you for your answer, but I was looking for a formula without
substitution, which will be more practical (for me). Any ideas?

Jack.

"Jack Sons" schreef in bericht
...
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