Dear all,
I have an excel file with the following information. The actual file name is at column A (FILE) but i want to rename it using the following: Column E (KKS) & ( & column F(TITLE) & ) & Rev & Column C (ISSUE).



FILE DOCUMENT IDENTIFICATION ISSUE DATE KKS TITLE PATH
483-21-DT-M-00300-Ed001.pdf 483-21-DT-M-00300 1 05-12-19 111915-21-YDS-MDD-EA-00300 P&ID SYMBOLOGY AND GENERAL NOTES PROJECT_483\200 Mechanical Area\221 Systems\221.01 P&IDs
483-21-FV-D-00001-Ed001.pdf 483-21-FV-D-00001 1 05-12-19 - Monthly Progress Report (NOVEMBER 2019) PROJECT_483\000 Project Management\001 General\001.03 Progress Reports
483-21-S-M-20250-Ed002.pdf 483-21-S-M-20250 2 04-12-19 111915-21-PA_-MHP-EA-20250 COOLING TOWERS (INDUCED DRAFT) DATA SHEET PROJECT_483\200 Mechanical Area\221 Systems\221.05 Data Sheets

Then each one of them must be send to a new folder location which is C:\Users\chma\Desktop\F2 - Copy & Column G (but the word PROJECT_483 must be repplaced by the C:\Users\chma\Desktop\F2 - Copy)
=i.e.
C:\Users\chma\Desktop\F2 - Copy\200 Mechanical Area\221 Systems\221.01 P&IDs\111915-21-YDS-MDD-EA-00300( P&ID SYMBOLOGY AND GENERAL NOTES)REV1.pdf

Thank you