converting letters to numbers

[mastertechs]

Hello All,

I have a very basic understanding on Excel and have trolled through youtube and this site but I am still lost.
If this topic has been covered already I apologize in advance.

I am working with a web designer and he asked me to produce product ID numbers. I decided to use letters to numbers to better organize and keep track rather than using random numbers that could accidentally be duplicated.

What I would like to do is type a word in excel and convert it to a stream of numbers. For example

A would be 1
B woud be 2
C would be 3
Z would be 26

So when I type a particular car the word can be converted to a stream of numbers based on the above logic.
When I type
AUDI it would be converted to 12149
BMW would be converted to 21323
CHEVY would be converted to 3852225

I'm not sure if this can be done but if there is a way to do it I know someone on here can teach me how.


Thanks for your help.

[Ghozi Alkatiri]

try it
=IFERROR(COLUMN(INDIRECT(MID(A1,1,1)&1)),"")&IFERROR(COLUMN(INDIRECT(MID(A1,2,1)&1)),"")&IFERROR(COLUMN(INDIRECT(MID(A1,3,1)&1)),"")&IFERROR(COLUMN(INDIRECT(MID(A1,4,1)&1)),"")&IFERROR(COLUMN(INDIRECT(MID(A1,5,1)&1)),"")

[FDibbins]

Very slick, Ghozi Just so the OP knows, that will do up to 5 letters, if they need more, all they have to do is add more...
&IFERROR(COLUMN(INDIRECT(MID(A1,5,1)&1)),"")

[Ghozi Alkatiri]

continue with
&IFERROR(COLUMN(INDIRECT(MID(A1,6,1)&1)),"") ..........an so on depend of how long data was