You are on the Home/Other Tutorials/Project Euler/Problem 22 page
Web This Site

Project Euler - Problem 22

More about Project Euler.

Problem description

Using names.txt (right click and 'Save Link/Target As...'), a 46K text file containing over five-thousand first names, begin by sorting it into alphabetical order. Then working out the alphabetical value for each name, multiply this value by its alphabetical position in the list to obtain a name score.

For example, when the list is sorted into alphabetical order, COLIN, which is worth 3 + 15 + 12 + 9 + 14 = 53, is the 938th name in the list. So, COLIN would obtain a score of 938 x 53 = 49714.

What is the total of all the name scores in the file?


I decided to do this in Excel.  As an intermediate step, I used Microsoft Word to reformat the data file.  Downloaded the data file, opened it in Word, replaced the comma with ^n (new line character) and deleted the double quotes  Then, I copied the names into Excel (cells A1:A5163.

In B1 enter =SUM(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))-CODE("A")+1)

In C1 enter =ROW()

In D1 enter =B1*C1

Copy B1:D1 down to 2:5163.

In D5164 enter =SUM(D1:D5163) and that is the answer.