Problem statement Every column is assigned a value, A =1 , B=2 ... and Z= 26. Again AA = 27, AB = 28.... and AZ = 52. Given a string S, find out the equivalent number. For example for AAA it will be 703. Analysis This problem has simple solution. We just need to come up with the mathematical formula for it. So let's work out some examples so that we can identify some pattern and then figure out formula.
Read full article from Algorithms and Me: Convert excel column to equivalent number.
