Analysis tool pak is not in english

B

Bottomwalk

In the excel add-in box, i find a number of options but they are all in
Turkish or s Aramaic or some language. Everything else in excel is in english!

Please help.
 
J

Jacob Skaria

If you have only two numbers in brackets...separated by spaces
A1 = (123) (456)
use the formula
B1 =SUBSTITUTE(LEFT(A1,FIND(")",A1)-1),"(",)+0
C1=SUBSTITUTE(MID(A1,FIND(" ",A1)+2,10),")",)+0

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Language of the templates 0
How to disable Alt+s in Outlook 365 0
Changing language from UK to US English 0
Excel - Wich Function should I use? 1
Tagging Misspell Words with "##" 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Data analysis Add-in unavailable in English in Excel 2007? 3

Top