Excel - Fill AA99D - Episode 1801
641 views · Published 7 October 2013 · 3:11 · Indexed 12 November 2026
Channel: MrExcel.com · 2013 · Education
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920