Learn Excel 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.