Need excel Formula/Function to replace old File name with new File name.
$2-8 USD (1시간 기준)
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.
프로젝트 ID: #6549727
프로젝트 소개
수상자:
이 일자리에 대한 프리랜서 8 명의 평균 입찰가: $5 (1시간 기준)
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