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!