Trick for alphabetical serial no. by formula in Excel

Description:

This file will contains the trick how to write the serial number alphabetically (ex - a,b,c,d,e,f..) through formula. Hope it will ease your work while working in Excel. #xlsx

Submitted By:

CA. Arvind Shrivastva

on 08 September 2018

Other files by the user

Downloaded:

1950 times

File size:

10 KB

Rating:

Download Other files in Info Technology category

Share Report

Upgrade to CAclubindia Pro. Subscribe Now!

Comments

05 March 2019 Bharani Kumar S

Could not be open excel

13 September 2018 kumar

sir nice formula suggested sir thank you very much sir

10 September 2018 Shalini Agarwal

Helpful, but difficult to remember. Thank you!

10 September 2018 CA. Arvind Shrivastva
Easy to remember: for Serial No. in capital letter. use formula =char(row(a65)) and for serial no. in small letter use formula =char(row(a97))