How to replace text with numbers? (formula)

  • Thread starter Thread starter Scott Adam
  • Start date Start date
S

Scott Adam

How do you convert a name eg ABCDE to a number eg 12345.?

where A=1,B=2,C=3 etc..

I need to input the name in 1 cell and see the converted number in adjacent cell,

So I know there will be some sort of lookup but I can not figure out how to lookup each letter.

Thanks

hope this makes sense.
 
How do you convert a name eg ABCDE to a number eg 12345.?



where A=1,B=2,C=3 etc..



I need to input the name in 1 cell and see the converted number in adjacent cell,



So I know there will be some sort of lookup but I can not figure out how to lookup each letter.



Thanks



hope this makes sense.
Click to expand...

Hi Scott,

Something like this, maybe.
Where D1 holds one of the letters.

=LOOKUP(D1,{"A","B","C","D","E"},{1,2,3,4,3})

Regards,
Howard
 
Hi Scott,



Something like this, maybe.

Where D1 holds one of the letters.



=LOOKUP(D1,{"A","B","C","D","E"},{1,2,3,4,3})



Regards,

Howard
Click to expand...

Typo, sorry.

=LOOKUP(D1,{"A","B","C","D","E"},{1,2,3,4,5})
 
Scott Adam said:
How do you convert a name eg ABCDE to a number eg 12345.?
where A=1,B=2,C=3 etc..
Click to expand...

What do you want to do with the J or K through Z?

If K=11, how do you distinguish the number for the "name" K from AA? Or
don't you care?

Finally, do you want the "number" to be treated as text or numeric? If the
latter, do you realize that Excel treat any digits after the first 15 digits
as zero?
 
Back
Top