Text to number

[alawami]

Hi Everyone I know that there is a way to change number to text using spell to number but is there a way to change text for example four to 4 . i have search the web and i found some sites offering this service but is it possible in excel.Thanks in advance.

[dominicb]

Good afternoon alawami

Try looking at this : https://contexturesblog.com/archives...bers-in-excel/

HTH

DominicB

[alawami]

Thank you Mr Dominicb for your quick reply,but the link you provided to me is archive and the pictures don't appear to explain the way to do it.So could you please give me the formula to change words or text to numbers.

[dominicb]

Hi alawami

... but the link you provided to me is archive and the pictures don't appear ....

Ahhh, yes. I didn't check that far.

Fortunately, Debra Dalgleish (owner of Contextures) has put together a file using the code with plenty of examples.
Below is a direct download link to access the file.

https://www.contextures.com/ExcelTem...SampleFile.zip

HTH

DominicB

[alawami]

I cannot thank you enough for your help! You are nothing less than a blessing from God!