Need excel Formula/Function to replace old File name with new File name.
$2-8 USD / ชั่วโมง
Hello,
I have an excel sheet with links, old and new file names, however I like to match the old file name to the downloaded file name by link.
So I need to match the new file name with the Old file name through the links, so I could rename the files. I can't organize/sort the files because they are missing some of the files.
example:
Excel Old file sheet:
Old File Name Link
B120 [url removed, login to view]
B121 [url removed, login to view]
B123 [url removed, login to view]
New Downloaded file names sheet:
Link New file name
[url removed, login to view] Book230
[url removed, login to view] Book 2785
[url removed, login to view] Book75
New and old name match through Links - NEED Formula
Old File New File name (Formula)
B120 Book230
B121 Book75
B122 Book2785
See attached file please.
Thank you.
หมายเลขโปรเจค: #6549727
เกี่ยวกับโปรเจกต์
มอบให้กับ:
freelancer freelancer 8 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $5/ชั่วโมง
Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan
Hello, i am interested in this job can do it ether by macro or by a desktop application send me the full excel sheet to begin Regards
i have 2+ year experience in MS-Office 100% work satisfaction Guarantee ready to start working soon as assign
