Business K201
Apr
23,
2017

To be honest, Excel's text functions are kind of awkward and limited. Unlike full-blown programming languages like Python and Javascript, you don't have access to regular expressions or standard string functions such as `split`

, `join`

, and `replace`

. Instead, you have to make due with complicated combinations of Excel's `LEFT`

, `RIGHT`

, `MID`

, `LEN`

, `FIND`

, and `CONCATENATE`

formulas to manipulate text.

In this video, we walk you through a common GP9 string (text) manipulation problem that asks you to use these functions to split, format, and rearrange text into more useful representations.

- GP6 - Amortization Tables (PMT) in Microsoft Excel

- GP8 - One- and two-variable data tables and what-if analysis

- K201: Quick Reference Guide for Microsoft Access

- GP9 - Text Functions - LEFT, RIGHT, MID, LEN, FIND, and CONCATENATE

- GP7 - Lookup Functions - VLOOKUP, HLOOKUP, MATCH, and INDEX

- GP6 - Present Value (PV), Future Value (FV), and Other Financial Formulas in Excel

- When to use INDEX-MATCH, VLOOKUP, or HLOOKUP

- GP5 - Aggregate functions (COUNT, SUM, AVERAGE, MAX, MIN) in Microsoft Excel

- GP6 and GP7 - IF Statements - Simple and Nested

- GP5 - Advanced aggregate functions (COUNTIF, SUMIF, AVERAGEIF)

- GP5 How to do date functions (TODAY,DATEDIF) and more complex formulas