replace or substitute a letter for a specific number
Hey david...
That doesnt work... it has to change only the letters... if i enter no
letter it is changing the numbers also... And, in case there is another
letter say in position6 of the number, it doent change it either...
but the macro is doing allright...
TNX
"David Biddulph" wrote:
=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
|