| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
this formulas is in English ... what is it in German?
Got it ... Thanks, Bob !
cheers Andrew "Bob Phillips" wrote: If you go into the VBIDE (ALt-F11), and ensure that the immediate window is open (Ctrl-G), and in there assign the formula to the activecell, in English (always in English), like so Activecell.Value = "=len(a1)-len(substitute(a1,""@"",""""))" If you then go back to Excel (Alt-F11), the formula will be in the local language, complete translation. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| German translation for english formulas | Excel Discussion (Misc queries) | |||
| Translate Excel 2000 file from German into English | Excel Discussion (Misc queries) | |||
| english equivalent to German formular <ARBEITSTAG? | Excel Discussion (Misc queries) | |||
| Insertion of formulas in foreign language in english version of ex | Excel Discussion (Misc queries) | |||
| Sharing worksheets between English and German versions | Excel Discussion (Misc queries) | |||
Threaded Mode
