I need help writing a function that pulls an inventory item number from a product description.
Here's the logic:
If COL C (Item Description) contains a consecutive 5 character numerical string, copy those 5 characters and write them to COL B and make COL D = "Custom". Otherwise, COL B= "0"& COL A and COL D= "Co Bill1".
Attached is a file with two tabs. The tab labeled "Done" shows the correct output from the formula (highlighted in yellow.)
Thanks for your help, experts! I really appreciate your help while I learn to do this.