Try

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Andrewsan" wrote in message
...
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