Get Column Name using Formula in Excel

How to get a column name in Microsoft Excel using a formula?

  • Click on a cell
  • Insert below formula:
  • =CHAR(COLUMN()+64)
  • Press enter



Popular posts from this blog

Formula to Get Country Flags in Google Sheets

Image
I have created a formula to insert country flags in Google Sheets's cells. For this I've used IMAGE, IMPORTXML and SUBSTITUTE functions. In this formula we're taking flag images from Wikipedia.   You can paste below formula in your Google Sheets: =IMAGE("https:"&IMPORTXML("https://en.wikipedia.org/wiki/Gallery_of_sovereign_state_flags","//img/@src[contains(.,'"&SUBSTITUTE(A2," ","_")&"' )]"))  Change A2 with the cell address in which you are typing country name. You need to type first letter of country name in capital letter in order this to work. I have explained this formula in my below YouTube video. You can watch this video to understand how it works:
Read more

Indian vs International Number System Chart (Lakh, Crore, Million, Billion)

Ever found yourself scratching your head when someone mentions a "Crore" or a "Billion" and you're trying to figure out the equivalent? You're definitely not alone! It's super common to get a little mixed up because the way we name and group really big numbers actually changes depending on where you are in the world. But don't worry, it's pretty straightforward once you see them side-by-side! This quick guide is here to clear up any confusion and help you smoothly switch between the Indian and International ways of looking at numbers: No. of Zeros Indian System International System Digit Representation 0 One One 1 3 Thousand Thousand 1,000 5 Lakh Hundred Thousand 1,00,000 ...
Read more