Thread: replace letter of alfanumeric value by a specific number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
El Criollo El Criollo is offline
external usenet poster
  
Posts: 13
Default 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

Reply With QuoteReply With Quote