Functions
11
Text Data
yrExcel
About this book
Intro to Excel
1
Entering and Formatting Data
2
Using keyboard "hot-keys"
Formulas
3
Intro to Formulas
4
Cell References
5
Cell References
6
Using the mouse to create formulas
Functions
7
Intro to Functions
8
Random Values
9
logical values (i.e. TRUE, FALSE)
10
dates and times
11
Text Data
12
Treating numbers as "plain text"
13
Summary of Data Types (numeric, text, logical, date)
14
Other topics (not finished editing yet)
Table of contents
Text functions and operators
right, left, mid
& operator and concatenate function
lower, upper, len functions
Functions
11
Text Data
11
Text Data
Text functions and operators
right, left, mid
& operator and concatenate function
lower, upper, len functions
10
dates and times
12
Treating numbers as “plain text”