Thread: replace or substitute a letter for a specific number
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 620
Default replace or substitute a letter for a specific number
=CODE(LEFT(A6,1))&CODE(MID(A6,2,1))&MID(A6,3,999)
--
David Biddulph

"El Criollo" wrote in message
...
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