See attached Spreadsheet:
I have a spreadsheet with 577 rows. As an example, I have one column of Categories in text, and I need the corresponding Category Code placed in the adjacent cell with the codes separated by commas.
Like this:
Category Text: Longevity Plus, All Products, Energy Support, Immune Support, Energy, Antioxidant
Category Codes: 2191,1819,2107,1961,2030
Even using find and replace, it will take too long. This is best done with an automated find and replace macro, which should be able to be done in 30 minutes if you know EXCEL Macros! The attached sheet has the corresponding codes in the second worksheet in the workbook, the first has the Category Text.
I need this done in 6 hours from this posting.