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