Excel-find difference between 2 letters

September 27, 2011 at 20:59:43
Specs: Windows 7
Hello. I am just learning Excel, so forgive me if there is a simple solution that I have missed!

I am trying to find a way to calculate the difference between two letters of the alphabet in two different columns.

Column A is a set of letters of the alphabet indicating proficiency levels at certain time of year (where A is lowest, B is better, C is better sill, and so on through the alphabet to Z). Column B is another set of letters indicating proficency levels (From A through Z) at a different time of year.

I want to find the difference to show growth over time. For example, if the value at A1 is C and the value at B1 is H, the growth in C1 would be +5 levels.

Is there an easy way to accomplish this? Do I need to replace the letter A with the numeral 1, B with the numeral 2, C with the numeral 3, and so on to write this formula (and what is the easist way to do that?)

Thank you!

See More: Excel-find difference between 2 letters

Report •

September 28, 2011 at 00:45:00
All characters have what is known as ASCII values A=65 Z=90 a=97 z=122
A1 = "C"
B1 = "H"
C1 = CODE(B1) - CODE(A1)
= 72 - 67
= 5

Report •

September 28, 2011 at 10:03:48
A minor correction to wizard-fred's response....

As written, with the quotes around C & H, the formula will return 0 since CODE() returns the ASCII value of the first character of the string - the double quote. Since both strings start with a double quote, the math will result in a 0 answer.

The example should have been written as follows:

A1 = C
B1 = H
C1 = =CODE(B1) - CODE(A1)
= 72 - 67
= 5

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question