Microsoft has recently introduced a new function within Microsoft Excel called REGEXEXTRACT() (Regular Expression).
"The REGEXEXTRACT function allows you to extract text from a string based on a supplied regular expression. You can extract the first match, all matches or capturing groups from the first match." - Microsoft
Office Newb Blog - Exercise File
https://www.officenewb.com/post/regex...