The product item number (ItemNo) that I need is buried in the product description (Description) field.
See sample file attached. Is there a way to run a macro or a procedure to extract the item number from COL and write it to Col B?
The item number is always at the end of the string but not all products have an item number. To demonstrate, I completed through row 8 manually.