yogi_Substitute Each Letter In A Name With A Number

Google Spreadsheet   Post  #2317

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-12-2017

question by: Melissa TW

https://productforums.google.com/forum/#!topic/docs/C6KfU5cnZ_U;context-place=forum/docs

Formula to replace every letter with a number
Hello, I have a list of employee names that I want to convert to numbers for employee IDs.

I'd like to use a formula to replace every letter in a cell with it's corresponding number, 1 through 26.

For example, the name "johnsmith" would be represented as 101581419139208

"a" equals "1" , "b" equals "2" , etc, etc.

Is there an easy way to accomplish this with one single formula?

THANKS IN ADVANCE