I NEED ONE XCEL FORMULA
Budget: ₹600 – ₹5,000 INR
I need alphabet series for data entry of my clothing wholesale shop
i have this formula but i need more than this it generates the alphabet from formula to zzzz
=UPPER(IF(ROW (A1)>18278,CHAR(96+INT(MOD(ROW (A1)- 18279,456976)/17576)+1),"")& IF(ROW(A1)>702,CHAR (96+INT (MOD (ROW(A1)-703,17576)/676)+1),"")&IF(ROW(A1)>26, CHAR(96+INT(MOD(ROW(A1)-27,676) /26)+1),"")&CHAR(97+MOD(ROW(A1)-1,26)))
I need from A to 10th zz... or maybe more than that
i have this formula but i need more than this it generates the alphabet from formula to zzzz
=UPPER(IF(ROW (A1)>18278,CHAR(96+INT(MOD(ROW (A1)- 18279,456976)/17576)+1),"")& IF(ROW(A1)>702,CHAR (96+INT (MOD (ROW(A1)-703,17576)/676)+1),"")&IF(ROW(A1)>26, CHAR(96+INT(MOD(ROW(A1)-27,676) /26)+1),"")&CHAR(97+MOD(ROW(A1)-1,26)))
I need from A to 10th zz... or maybe more than that