This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.

When working with a large data set, you would be more productive if you knew how to quickly find what you need. Luckily, Excel has a few functions that can help with this. The FIND Function 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 ...

Note: SAS functions used in a WHERE expression that can be optimized by an index are the SUBSTR function and the TRIM function. For more information on SAS functions, see Functions and CALL Routines ...

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 ...