Tuesday, December 12, 2017

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
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?