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.