# How to replace text with numbers? (formula)

S

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

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?