Extract text from a string
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.
Extract-ItemID-from-product-desc.xlsx
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.
Extract-ItemID-from-product-desc.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER