I want to test that all the product codes match this structure ... such as using the TEXTSPLIT function or Excel's Flash Fill tool. This function takes text in a cell and creates a new version ...

The FIND Function in Excel returns the numerical position of a specified character or string (sequence of characters) within a larger string. It's useful for precise text extraction, manipulation ...