Arne,

This is one of many such questions you have asked, so time to give you a
generic solution.

In the Immediate window in the VBIDE (Alt-F11, Ctrl-G), type

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

go back to Excel, and you will see the Swedish equivalent.

The only thing to beware of is the quotes, you need to double up these, or
just break it down, such as

Activecell.Formula = "=MID(A1,1,2)"

and

Activecell.Formula = "=SEARCH(x,A1,3)"


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arne Hegefors" wrote in message
...
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!