Find Excel column name from a given column number MS Excel columns has a pattern like A, B, C, … ,Z, AA, AB, AC,…. ,AZ, BA, BB, … ZZ, AAA, AAB ….. etc. In other words, column 1 is named as “A”, column 2 as “B”, column 27 as “AA”. Given a column number, find its corresponding Excel column name. Following are more examples. Input Output 26 Z 51 AY 52 AZ 80 CB 676 YZ 702 ZZ 705 AAC We strongly recommend to minimize the browser and try this yourself first.
Read full article from Find Excel column name from a given column number | GeeksforGeeks
No comments:
Post a Comment