Merge Excel Products files - clean up UPC field and add Column with new data

I have two files that i need to have merged together and data formatted properly for CSV import. There are a few tasks that need to be done and I will explain them here: 1. In main file (Product Export) , write a Macro to clean up UPC Field ( currently has extra digit and some spacing that neds to be removed it currently looks like this 0 83000 00116 1 and it should look like 83000001161 2. In the Category field, We want to Add 1 brand to all categories. ( So that will need a Macro as well) 3. In the Cross Sell column, we need to add the Cross - Sell UPC's as defined in the 2nd sheet (Similar Items .xlsx) The logib will be match the UPC (already fixed in step 1) then add the 3 upc's from the cross sells listed in sheet 2 (separated by acomma) 4. Save as CSV for import . 5. the job will be considered complete when an import is done succesfully. 6. I will be available on chat to walk thru this with you .