Forum Discussion

aa aaaa's avatar
aa aaaa
Copper Contributor
Nov 12, 2018

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.

     

    • aa aaaa's avatar
      aa aaaa
      Copper Contributor

      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.

Resources