How to Drag and Autofill Alphabet to Get AA, AB, AC Values in Excel

[@lonniestewart7939]

How would the code look if you wanted to exclude certain alpha characters like "I", "O" or "Q" etc... from your function output?

[@MrMulrine83]

easier to enter A in cell A1 and then in B1 type =SUBSTITUTE(ADDRESS(1,ROWS(A$1:A1),4),1,"") and drag down

[@Excel10tutorial]

Thanks a million for your input.

[@1Uchiha_Madara]

Thank youuuuu

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.

[@manu6383]

Thank you!

[@Excel10tutorial]

You are most welcome

[@faisalashraf8816]

Superb

[@Excel10tutorial]

Thank you! Cheers!

[@AgusSalimMaksum]

Thanks ✍️

[@Excel10tutorial]

Most welcome. Please subscribe and be with us.

[@Gert-JanLeutscher]

Whenever i try this i get a value error. Any suggestion?

[@JordanGoh-oj1hz]

Use the number one (1) in your VBA code instead of the lowercase L.

[@TheSundaySims]

@@JordanGoh-oj1hz this didn't work. I'm getting VALUE error too.

[@rezashamim6390]

Where I find the VBA code?

[@Excel10tutorial]

Link is in the video description

[@navalsharma6246]

Please share excel sheet of above formula, ready made

[@Excel10tutorial]

Check description

[@navalsharma6246]

​@@Excel10tutorialneed excel sheet.plz share

[@MohAboAbdo]

Thank you so much Sir

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.