Thread: replace or substitute a letter for 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 or substitute a letter for a specific number
Say A=65, B=66, C=76.. Z=90
I want to convert the alfanumeric value "AB25" into 656625...
Cant find the way to replace/substitute A for 65 and B for 66 followed by 25
to make a
single number...
Is this possible???
THANX


Reply With QuoteReply With Quote