MID in Swedish Excel?
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! |
MID in Swedish Excel?
Hi,
The MID function extracts a string of text from the middle of a string of text. See he 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! |
MID in Swedish Excel?
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! |
MID in Swedish Excel?
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! |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com