Excel - Fill AA99D - Episode 1801

641 views · Published 7 October 2013 · 3:11 · Indexed 12 November 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: How to Fill a Series of Serial Numbers (AA10B to AA11B) | MrExcel Podcast.

Welcome to another episode of the MrExcel podcast. In this episode, we will be discussing how to fill a series of serial numbers in Excel, specifically from AA10B to AA11B. This question was sent in by Mohammed Desouki, who was struggling to find a solution for this particular scenario.

At first glance, it may seem like a simple task to just select the cells and drag the fill handle down to generate the next numbers in the series. However, as we know, Excel has its own set of rules and limitations. When the numbers are in the middle of the series, such as in FF10 D and FF11 D, the fill handle does not increment the numbers as expected.

To overcome this issue, I suggested to Mohammed to use the =LEFT and =MID functions to break down the serial numbers into smaller parts. By combining these functions with the +1 operator, we can create a formula that will increment the numbers in the series as we drag it down. This method may seem a bit complex, but it is a workaround to achieve the desired result.

However, there is still one more hurdle to overcome. When we reach FF99D, the formula will temporarily go up to 100D, but then it will reset back to 11D. To avoid this, we can use the =LEN function to dynamically adjust the formula based on the length of the serial number. This way, it will work for any length of the number, up to 15 digits.

I hope this video has helped you understand how to fill a series of serial numbers in Excel. Don't forget to subscribe to our channel for more helpful tips and tricks. Thank you for watching, and we'll see you in the next episode of the MrExcel podcast.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Introduction and Sponsorship
(00:10) Episode Topic: Filling Serial Numbers
(00:21) Dragging Down to Generate New Numbers
(00:31) Limitations of Excel's Fill Handle
(00:42) Incrementing Numbers with Words
(01:01) Using Formula to Increment Numbers in Middle
(01:56) Limitations of Formula with High Numbers
(02:14) Improving Formula with LEN Function
(03:01) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Drag down increment in Excel
Excel fill handle limitations
Excel fill handle not working
Excel formula for incrementing serial numbers
Excel LEN function explanation
Excel serial number increment
Handling long numbers in Excel
How to extend numbers in Excel
Increment numbers with words in Excel
Incrementing numbers in Excel formula
MrExcel podcast episode 1801: Fill AA10B to AA11B
Using LEFT and MID functions in Excel

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153622/


You have serial numbers like AA10D, AA11D and want to fill to AA12D, AA13D, and so on. The Excel Fill Handle won't do this. Learn how to solve it with a formula.

More from this channel