Please find the below example. Copy the formula to the other rows

A1 = C:\sample.jpg (hyperlink)
B1 = D:\temp\ (new path)
C1 = HYPERLINK(SUBSTITUTE(A1,"C:\",B1))


If this post helps click Yes
---------------
Jacob Skaria


"AskExcel" wrote:

hi,
i have excel sheet with link cell to many source of excel sheet.
when the source changed path, i need to manually change it via edit link
under data menu.
may i know if there is any easier way to change once instead of change it 1
by 1.
if macro can achieve this, how?
need advice.
thanks