Contents
Overview.. 4
A Note Regarding Excel
Versions in this Course. 4
Numbers Formatted as Text. 5
Using Text to Columns. 15
Commonly Used Text Functions. 22
Review Questions. 28
Evaluating Text. 29
Cleaning Up Text. 35
Working with Dates. 37
New Text Functions in Excel
2016. 39
Review Questions. 44
Glossary. 45
Index. 46
Exam Questions. 47
Answers to Review Questions. 49