Episode 156 - Text Calculations in Excel

Use Excel to calculate text. In this podcast, learn how to join a first name in column A with a last name in column B. Also use a function to convert upper case text to either lower or proper case. Finally, learn how to convert live formulas to values in order to be able to delete the original columns. Episode 156 will show you how.

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