'Convert Arabic character to English Excel
I have one column (E) trying to change the Arabic characters to English one. these data i import it as it is from JSON file. How to change these Arabic characters and remove its date, I only want the repetition times. Thanks in advance.
Here is the link of the file
Solution 1:[1]
try this formula in column F and copy and paste it across to each row in column F:
You can change the Hindu-Arabic numbers to West-Arabic in excel by a simple quick fix like this: (change the cell A1 to your cell). It also changes the dot.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"?","0"),"?","1"),"?","3"),"?","4"),"?","5"),"?","6"),"?","7"),"?","8"),"?","9"),"?","2"),"ยท",".")
This assumes you are on row 8 as in the screenshot below:
=RIGHT(E8,8)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |