Don’t copy and paste the same code over and over again. Instead, create a PowerShell function and save yourself time.
How to Extract a Substring in Excel Using FIND() and MID() Functions Your email has been sent Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data.