Though Bill has looked at this topic in previous episodes, today he shares a tip from a Mary. It is an interesting thing that Excel will address certain Alpha-numeric arrangements with the Fill Handle in chronological order, while other alpha-numeric arrangements it will not. Follow along with Episode #1722 as Bill highlights several configurations of Quarter Designation and shows us how we can work with Excel to get our desired results.

[youtube=http://youtube.com/watch?v=7lM5QpPECFM]

“Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

 MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!