MID in Swedish Excel?

[Arne Hegefors]

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!

[Dave F]

Hi,

The MID function extracts a string of text from the middle of a string of
text. See here: http://www.techonthenet.com/excel/formulas/mid.php'


--
Brevity is the soul of wit.


"Arne Hegefors" wrote:

> 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!

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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!

[Harald Staff]

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" <[email protected]> skrev i melding
news:[email protected]...
> 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!