View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default 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