Text Functions Syllabus

Text Functions

This course covers Text Functions and consists of 13 topics.

Left, Right, Mid, Len, and Concatenate Functions – This video shows how to use the LEFT, RIGHT, MID, LEN and CONCATENATE functions to manipulate text in a single cell.
Find Function and Text to Columns – This video shows how to use the FIND function and TEXT to COLUMNS to parse data in a single cell.
Histograms – This video shows how to use the REPT function to create a simple histogram.
Clean Function – This video shows how to Use the CLEAN, FIND, and SUBSTITUTE functions to remove invisible characters from your data.
Flash Fill – This video shows how to use FLASH FILL in Excel 2013 and 2016 to automatically perform the work of text functions.
Control + E and Flash Fill – In this video we show how Control + E makes Flash Fill perform better.
Finding the Last Word – This video shows how to use the SUBSTITUTE function to find the last word in a cell.
Two Column Lookup – This video shows how to use a VLOOKUP based on multiple columns of data.
Social Security Numbers – This video shows how to turn Social Security Numbers into PeopleSoft IDs.
Unicode – This video shows how to use Excel’s vast library of UNICODE characters.
Creating an Email List With Text Functions – This video shows how to take a list of email aliases and turn it into an email list.
The TEXT Function – In this video we show how the TEXT function can ensure that a value in one cell is converted in a different cell to any desired number format.
The ROUND, ROUNDUP, ROUNDDOWN, and INT Functions – In this video we show how to use the ROUND, ROUNDUP, ROUNDDOWN, and INT functions to round numbers in any desired fashion.
Learn More