Today's episode is a reversal of Episode #1517 [click link to view]. In Episode #1520, Bill looks at two ways to solve the problem where you have text and a date in the same cell and the goal is to isolate only the date.

[*Note - Bill mentions Episode #1518 in this podcast, but he is actually referring to Episode #1517*]

…This episode is the video podcast companion to the book, “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! and 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!

Today Bill shows us how to use the Macro Recorder to record the action of Double-clicking the Fill Handle. It isn’t as straight-forward as you might think, but it can be done with only the macro recorder. Follow along with Bill in Episode #1519 to learn how.

...Today's Podcast topic may be found in Bill's book, "VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy Syrstad. The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve...Includes crucial information on making Excel 2010 VBA code work with older versions.

“The Learn Excel from MrExcel Podcast Series”

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

With a list of Products and a list of Dates, Bill's mission is to find the last order date for each product in the Dataset.Learn the use of MAXIF, changing Number Formats, and more in Episode #1518. [Previously slated as Episode #1516]

Today’s Episode is brought to you by… New for 2012! “CFO EXCEL PRO“: a New, weekly e-Newsletter Publication from CFO.com featuring Bill “MrExcel” Jelen! CFO Excel Pro offers, “… clear, concise illustrated articles written by Microsoft MVP Bill “Mr. Excel” Jelen that provide readers with step-by-step solutions to nagging “real-world” Excel problems.

“The Learn Excel from MrExcel Podcast Series”

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

From a YouTube Viewer, Bill looks how to have text and actual dates reside in the same Cell. Follow along with Episode #1517 to learn how to add Custom text to your Date Field while retaining the actual Date.

…This episode is the video podcast companion to the book, “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! and 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!

Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin compare data in columns to discern whether 'same' figures exist in both columns, by row. Bill goes the VBA Route and Mike chooses to use an Amazing Array Formula to get the query solved. Watch Episode #1516 to learn a wide variety of uses for Excel VBA and Excel Functions.

Dueling Excel Podcast #98…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“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! and 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!

Today in Episode #1515 we have a series of Dates. We want to show quarters for the year 2012. Bill 'MrExcel' Jelen goes Old School on this one while Mike 'ExcelisFun' Girvin goes for a more Functionally 'stream-lined' approach. Mike and Bill look at the =CEILING, =MONTH, VLOOKUP functions and more.

Dueling Excel Podcast #97…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“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! and 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!

VJ types a value into his spreadsheet and Excel speaks the entry; but VJ doesn't want Excel to speak the entry and 'Stop Speaking Cells' -on the Quick Access Toobar- is not making it stop. Why? Follow along with Bill in Episode #1514 to learn why the cells won't stop speaking and then learn how to turn off the 'Speak On Enter' function.

Today’s Episode is brought to you by… New for 2012! “CFO EXCEL PRO“: a New, weekly e-Newsletter Publication from CFO.com featuring Bill “MrExcel” Jelen! CFO Excel Pro offers, “… clear, concise illustrated articles written by Microsoft MVP Bill “Mr. Excel” Jelen that provide readers with step-by-step solutions to nagging “real-world” Excel problems.

“The Learn Excel from MrExcel Podcast Series”

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

Mike and Bill look at two methods to lookup a column of sales amounts in order to create a single cell formula that will add all the bonuses. Learn more about the LOOKUP function, how to use SUM and SUMPRODUCT and Array Formulas in Episode #1513.

Dueling Excel Podcast #95…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“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! and 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!

Charlie -who admits he is relatively new to Microsoft Excel-  needs to rearrange the rows of his spreadsheet. Today, in Episode #1512, Bill shows us several methods to accomplish this task.

Today’s Episode is brought to you by… New for 2012! “CFO EXCEL PRO“: a New, weekly e-Newsletter Publication from CFO.com featuring Bill “MrExcel” Jelen! CFO Excel Pro offers, “… clear, concise illustrated articles written by Microsoft MVP Bill “Mr. Excel” Jelen that provide readers with step-by-step solutions to nagging “real-world” Excel problems.

“The Learn Excel from MrExcel Podcast Series”

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

Richard has a Data Series Set up with Year, Female, Male; after moving from Excel 2003 to Excel 2007, Richard noticed that the Chart is giving three (3) Series instead of two (2). With a few simple clicks in Episode #1510, Bill "MrExcel" Jelen solves the additional series issue.

Today's Episode is brought to you by... New for 2012! "CFO EXCEL PRO": a New, weekly e-Newsletter Publication from CFO.com featuring Bill "MrExcel" Jelen! CFO Excel Pro offers, "... clear, concise illustrated articles written by Microsoft MVP Bill "Mr. Excel" Jelen that provide readers with step-by-step solutions to nagging "real-world" Excel problems.

The Learn Excel from MrExcel Podcast Series - Visit Us Today!

Today's Dueling Challenge: "Conditionally Format End Values that have Increased or Decreased by 15%"

Initially, it appears that there is only one way to accomplish this task, but Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen find another way to tackle and solve this challenge. Follow along with Episode #1509 to see how its done!

Dueling Excel Podcast #95…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“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! and 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!

The Question: "I have a =COUNTIF to count values less than 10 and another to count values less than 20; but how do I count the values that fall between 10 and 20?" In 2007 and newer, there is a New Function called '=COUNTIFS". Follow along with Bill in Episode #1508 to learn how to solve this question - even if you are using Excel 2003 or earlier!

…This episode is the video podcast companion to the book, “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! and 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!

Today's Learn Excel Question: "Can you use Excel to generate Random Numbers that are centered around a mean using a Standard Deviation?" =RANDBETWEEN won't do it, but a clever use of =RAND and =NORM.INV ["Normal Inverse"] will do it. In Episode #1507, Bill shows us how to generate Random Numbers with this method.

…This episode is the video podcast companion to the book, “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! and 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!

Simons gets an accounting file from the company system. When he opens the accounting file, some G/L [General Ledger] codes are converted from the " N-NN-NNNN " Format to Dates, by Excel. Today, how to prevent this from happening is the subject Bill works with in Episode #1506.

…This episode is the video podcast companion to the book, “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! and 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!

The Question: "How do I generate the next Invoice Number?" Microsoft Office Online offers a great number of Invoice Templates. However, none of those templates has a Macro to pull the next Invoice Number. Today, in Episode #1505, Bill shows us how to 'Macro Enable' our Workbook and then create a short VBA Code routine to automatically generate Invoice Numbers with the press of a mouse button.

…This episode is the video podcast companion to the book, “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! and 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!