Definitive Text Function Guide

The purpose of this class is to introduce you and guide you on how to use the various Microsoft excel text functions. We use text throughout excel but quite often that text maybe formatted wrong or require enhancement and we can use certain excel functions to restructure and reformat it to ensure it can be used and presented correctly.

This Excel course covers the following:

Transpose
Concatenate
Trim
Clean
Upper and Lower
Proper
Left, Right and Mid
Text
Len
Find
Substitute
Replace
Split First name and Last name
By the end of this course should be proficient with using these formulae and understand their uses and how they can enhance your day-to-day work.

Screenshots