ExcelBanter - Analysis tool pak is not in english

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Analysis tool pak is not in english (https://www.excelbanter.com/excel-discussion-misc-queries/233941-analysis-tool-pak-not-english.html)

Bottomwalk

Analysis tool pak is not in english

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.

Jacob Skaria

Analysis tool pak is not in english

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
---------------
Jacob Skaria

"Bottomwalk" wrote:

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.

Jacob Skaria

Analysis tool pak is not in english

Oops..Please ignore the below post
--
If this post helps click Yes
---------------
Jacob Skaria

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria

"Bottomwalk" wrote:

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.

All times are GMT +1. The time now is 10:37 AM.