ExcelBanter - replace letter of alfanumeric value by a specific number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - replace letter of alfanumeric value by a specific number (https://www.excelbanter.com/excel-discussion-misc-queries/121689-replace-letter-alfanumeric-value-specific-number.html)

El Criollo

replace letter of alfanumeric value by a specific number

Say A=65, B=66.. etc..
I want to convert the alfanumeric value "AB25" into 656625...
Cant find the way to replace A for 65 and B for 66 followed by 25 to make a
single number...
Is this possible???
THANX

David Biddulph

replace letter of alfanumeric value by a specific number

See your later post.
--
David Biddulph

"El Criollo" wrote in message
...
Say A=65, B=66.. etc..
I want to convert the alfanumeric value "AB25" into 656625...
Cant find the way to replace A for 65 and B for 66 followed by 25 to make
a
single number...
Is this possible???
THANX

All times are GMT +1. The time now is 08:23 AM.