Devam Ediyor

Need excel Formula/Function to replace old File name with new File name.

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.

Beceriler: Veri İşleme, Excel

Daha fazlasını görün: sort function, excel sheet formula, excel formula, excel replace formula, need match files excel, excel match formula, need formula, formula sheet, file name excel, replace files, excel data match, replace formula excel, need excel, need excel sheet, please attached file, need excel file chocolate, sheet names excel, processing sheet excel, sort file excel, function data processing, sheet names excel file, match excel sheet, match names excel, formula sheet excel, links excel sheet

İşveren Hakkında:
( 23 değerlendirme ) Santa Clara, United States

Proje NO: #6549727

Seçilen:

Khurramz

Hello! I have the formula. Please send me chat to get that for $3 only. Regards Khurram .

3$ USD / saat
(24 Değerlendirme)
4.1

8 freelancer bu iş için ortalamada 5$/saat teklif veriyor

sawangupta

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

4$ USD / saat
(21 Değerlendirme)
5.1
ahmedsobherfan

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

4$ USD / saat
(20 Değerlendirme)
3.6
P0L

A proposal has not yet been provided

8$ USD / saat
(4 Değerlendirme)
2.2
patelhemang12

i have 2+ year experience in MS-Office 100% work satisfaction Guarantee ready to start working soon as assign

4$ USD / saat
(5 Değerlendirme)
2.2
omerqayyum789

100% job satisfaction. i am expert and professional in excel and doing excel modeling since 2011. i ll show you my previous work done. looking forward to work with you in the future.I know the time is so important. i w Daha fazlası

2$ USD / saat
(0 Değerlendirme)
2.9
m7jalal

A proposal has not yet been provided

7$ USD / saat
(0 Değerlendirme)
0.0
killibris

Hello :) need this job, please try me

5$ USD / saat
(0 Değerlendirme)
0.0