Episode 536 - Indeterminate Substitution

Robbie calls in today to ask how to add a hyphen at an unknown position in each cell. For example, whenever Excel finds a period, add a dash. There are three solutions to this problem. Episode 536 compares them all.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 525 - MegaFormula Redux

Gary sent in a better way to build MegaFormulas. Gary must be catching up on old podcasts, because he sent a note about Episode 387. Compare my way and Gary’s way of building MegaFormulas in Episode 525.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 522 - Finding Numerics

The Find command seems to work perfectly with text, but always has problems with finding numeric values. It is possible to find numbers with the Find command in Excel, but you have to know some fairly arcane steps. Episode 522 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 424 - Toolbar Hyperlinks

More tricks for your Excel toolbars, including how to edit the icons or how to add an icon to the toolbar that opens a particular webpage, perhaps www.MrExcel.com! Episode 424 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 408 - 2 Column TextBox

How to use Excel as a word processor. This episode again covers the Edit - Fill - Justify command, but also shows off the cool ability to create a two column text box in Excel 2007. Episode 408 shows you how.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!