Tjena Arne

This simple macro makes Excel do the all the translation work for you:

Sub Translate()
ActiveCell.Formula = _
InputBox("Engelsk formel:", _
"Översättaren", _
ActiveCell.Formula)
End Sub

HTH. best wishes Harald

"Arne Hegefors" skrev i melding
...
I have some Excel formulas that I want to use. These fomulas refer to the
English Excel and I have a Swedish version. One of the fomulas looks like:

=MID(B2,SEARCH(" ",B2,3)+1,4)

But I do not know how to translate the MID to swedish. Can someone please
help me with this? Thanks very much!