_Banner_Advanced_Formulas_Functions-Red.webp)
Chapter 11
Text Functions
Locating & Extracting Data with FIND, SEARCH, & MID Functions
Chapter 11
Text Functions
Extracting Specific Data with LEFT & RIGHT Functions
Chapter 11
Text Functions
Use TRIM Function to Remove Unwanted Spaces in a Cell
Chapter 11
Text Functions
Use Ampersands & CONCATENATE to Combine Data from Different Cells
Chapter 11
Text Functions
Use CONCAT & TEXTJOIN to Combine Data from Different Cells
Chapter 11
Text Functions
Adjusting Alphabetic Case with UPPER, LOWER, & PROPER Functions
Chapter 11
Text Functions
Adjust Character Content with REPLACE & SUBSTITUTE Functions
Chapter 11
Text Functions
Using the Utility Text Functions-TEXT, REPT, & LEN
Chapter 12
Information Functions
Extracting Information with CELL & INFO Functions
Chapter 12
Information Functions
Using ISBLANK, ISODD, ISEVEN, ISTEXT, ISNONTEXT, & ISNUMBER
Chapter 12
Information Functions
Using ISERR, ISERROR, IFERROR, & ISNA Error-Checking Functions
Chapter 12
Information Functions
Tracking & Highlighting Formula Cells with ISFORMULA Function
