Parsing Data Using Regex to Return Desired Values
I need to parse rows of data to extract a 3-4 letter code which is in all caps and create a new column containing those codes (RHL in this example) Inv RHL - Earn/Loss I can't use left/right functions because each account will have a different # of characters on each side of the code. Regex in replace text only allows you…
