Forum Discussion
convert non English text to number
In attached file, there is some number-look text in Arabic font . I couldn't convert them to number. non of these 4 ways helped me:
1- use Value function
2- use paste special
3- use error checking
4- use text to column
Please help me to convert these text to number.
Hi,
It looks like you copy that from Web. You have some extra symbol at the end of your arabic numbers. If you double click on the cell and remove it when works. Or use
=VALUE(LEFT(A1,LEN(A1)-1))
But not always - perhaps there are more not-numeric symbols. Please check attached, that could give you an idea.
Thank you very very much.
I copy them from html file. You are right, there was an extra character, a non breaking space (ctrl+shift+space). your solution was excellent.
