Home

convert non English text to number

aa aaaa
Occasional Contributor

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.

 

2 Replies

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.

Related Conversations
Problems with formating text within a cell.
Maciej Fox in Excel on
10 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies
Superscript and Subscript ribbon buttons
Lenoire77 in Excel on
3 Replies
Giant stupid numbers
Headaking in Excel on
4 Replies