Loading

How to convert letters to number?

How to convert letters to number?

ValoChele

8y15.9kVisual Basic .NET

What is the easiest way of converting a letter to integer in below fashion

A=1,

B=2,

C=3 ,

....

Z=26.

Also the small letter counterparts will have the same value is well, like "c" should also be equal to 3 and so on.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ankit Sharma8y ago
Accepted answer
Hi,

Please update your code as below
internal static int lettertonumber(char letter)
{
     int index = char.ToUpper(letter) - 64;
     return index;
}
static void Main(string[] args)
{
    int v= lettertonumber('d');
     Console.WriteLine(v);

     Console.ReadLine();

}
Hope this will solve your problem.
+2
Bhuvanesh Mohankumar8y ago
1. ///
2. /// A -> 1
3. /// B -> 2
4. /// C -> 3
5. /// ...
6. ///
7. ///
8. ///
9. public static int NumberFromString(string column)
10. {
11. int retVal = 0;
12. string col = column.ToUpper();
13. for (int iChar = col.Length - 1; iChar >= 0; iChar--)
14. {
15. char colPiece = col[iChar];
16. int colNum = colPiece - 64;
17. retVal = retVal + colNum * (int)Math.Pow(26, col.Length - (iChar + 1));
18. }
19. return retVal;
20. }
0

Ankit Sharma

Ankit Sharma8y ago

Hi ,

Please use this code to get your desired output

class Program
{
static void Main(string[] args)
{
lettertonumber('z');
Console.ReadLine();
}
internal static void lettertonumber(char letter)
{
int index = char.ToUpper(letter) - 64;
Console.WriteLine(index);
}
}

Try and let me know if it works for you

+1

Nilesh Patil

Nilesh Patil8y ago

Hi,

Refer this

https://stackoverflow.com/questions/1951517/convert-a-to-1-b-to-2-z-to-26-and-then-aa-to-27-ab-to-28-column-indexes-to

+1