Need this formula translated into Swedish

[Ekbergj]

Please help me translate this formula into swedish Excel

=LOWER(REPLACE(A1,1,FIND("@",A1)-1,(SUBSTITUTE(B1," ","."))))

Kind regards
Johan

 

[fairwinds]

Hi,

=GEMENER(ERSÄTT(A1;1;HITTA("@";A1)-1;(BYT.UT(B1;" ";"."))))

(untested)

Check out
http://www.xldennis.se/

for dictionary and formula translator add-in