Hi Everyone

my laptop uses Excel 2003 English ... and my desktop Excel 2003 German.

This formula goes in cell b1 ...
it counts the number of times the character '@' appears in cell a1 ...

=len(a1)-len(substitute(a1,"@",""))

my question: how to write this formula in German for Excel 2003?

this is what I have tried so far:

=LÄNGE(A2)-LÄNGE(ERSETZEN(A2;"@";"";""))

unfortunately Excel doesn't like this and throws up the #WERT error message.

Can anyone help with a correction / alternative that will achieve the same
objective?

cheers,
Andrew