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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies