Assign a number to items from a keyword in the name

Originally Posted by samuelabyrd

Thank you for the help. I'm not sure I'm clear on what portions of the code I need to edit. Please advise.

Are you asking where to place the code in the workbook?

1. Open the VBA editor. Not 100% sure how to do that in excel 2003, but try using alt+F11; otherwise, google how to open it for your version.
2. Insert a new module. Google for instructions for this as well.
3. Paste the above code into the module.
4. Type in the formula "= AssignNumber(CellNumberGoesHere)" into the cell and it should assign the id number.

Edit: fixed typo in line #4 as per following reply