Let’s look at a quick example using the sample data shown in Figure A. Figure A. The MID() function returns a substring from the middle of a source string. Specifically, ...

The above formula will return 9, since the substring 12345 starts at that position. ... It has a similar syntax to the FIND function. =SEARCH(search_text, text_to_search_in, ...

This function is similar to Excel's REPLACE function, but also supports RegEx. It takes the text string you want to modify and checks to see if there is a substring that matches the defined regex ...

For example, the %SUBSTR function creates a substring of another string, while the %UPCASE function converts characters to uppercase. A special category of macro functions, the macro quoting functions ...