Learn how to use the Concatenate function to combine text from multiple cells into a single cell. The Trim function is great for cleaning up extra characters in your data. The Proper, Upper and Lower functions will help you to adjust the case of your text. These functions are great for correcting data entry mistakes.

Understand the subtle differences between the Substitute and Replace functions. The Substitute function changes text based on the contents whereas the replace function changes text based on its location. This video helps you to understand when to use each function.

Learn how to use the Left, Right, Find and Len functions in Excel to extract different portions of text from one cell into another cell. These functions are great for manipulating data to get just the part you need.