How to replace text with numbers? (formula)

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.
 
L

lhkittle

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.

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
 
L

lhkittle

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

Typo, sorry.

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

joeu2004

Scott Adam said:
How do you convert a name eg ABCDE to a number eg 12345.?
where A=1,B=2,C=3 etc..

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top