Need to convert a number from a parsed Arabic sentence to a number

[Nineball]

After parsing an Arabic sentence that contains a number, the number appears at the right hand side of the cell. I believe the number appears as text. Any formula on the cell results in #VALUE.
I haven't found any function that will change it to a number. Any suggestions? thanks

 

[Nineball]

That's not what I got.
I copied your example from post #9 then pasted it in a text editor then from there copy 17 to excel, here's what I got:

Book1
	A	B
1	لەن	1604
Sheet1

Cell Formulas
Range	Formula
B1	B1	=UNICODE(A1)

so 17 became لەن

how did you test the 17? Did you copy it from the cell or did you create a new cell with the 17 as the result and then check?

 

[Nineball]

how did you test the 17? Did you copy it from the cell or did you create a new cell with the 17 as the result and then check?

Look at post 15 to see how I extract the cell. If my process is flawed, and there is a better way to extract the number, my eyes are wide open

 

[Nineball]

Look at post 15 to see how I extract the cell. If my process is flawed, and there is a better way to extract the number, my eyes are wide open

 

[Akuini]

how did you test the 17? Did you copy it from the cell or did you create a new cell with the 17 as the result and then check?

Sorry, I think I messed up the part that I copy-paste. It's actually hard to navigate/select part of text with right to left orientation.
I mean I selected 17 in the text editor but actually it was different part that get selected.
I'll try something else then.

Could you upload a sample workbook (without sensitive data) to a sharing site like dropbox.com or google drive?
And then share the link here.
It will be easier to test if I have the workbook.

 

[Nineball]

I think you might be on the right path with the ascii

Sorry, I think I messed up the part that I copy-paste. It's actually hard to navigate/select part of text with right to left orientation.
I mean I selected 17 in the text editor but actually it was different part that get selected.
I'll try something else then.

Could you upload a sample workbook (without sensitive data) to a sharing site like dropbox.com or google drive?
And then share the link here.
It will be easier to test if I have the workbook.

I haven't done this before but I think this is the link for the google drive folder: Google Drive: Sign-in

 

[Nineball]

Loading Google Sheets

 

[Nineball]

let me know if either of those worked

 

[KRice]

@Nineball, could you confirm your Excel version, please? You're using Excel 2010? I think I've discovered an alternative approach, but it uses Excel 365 functions...which may not be useful to you.

 

[Nineball]

I set up a folder with dropbox. I don't use dropbox or google drive so I don't know what I'm doing.

Mr. Excel Question.xlsx

Shared with Dropbox

www.dropbox.com

 

[Nineball]

@Nineball, could you confirm your Excel version, please? You're using Excel 2010? I think I've discovered an alternative approach, but it uses Excel 365 functions...which may not be useful to you.

Excel 2021