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

Data analysis Add-in unavailable in English in Excel 2007? 3
Problem with Regression function in 2007, Analysis Tool Pak 2
How do I install Excel 2000 Analysis Tool Pak? 3
add ins-Analysis Tool Pak without disk 2
Excel 2007 Data Analysis Toolpack 3
How do you get tool-pak or ph stat on excel 07 program? 1
Help! Excel 2007 Ribbon Is Missing Add-Ins Tab 2
Decimal point in bar chart and similar 1

Top