Top urgent for hyperlinks management

[Ramadan]

my excel sheet is a huge one and I have a column that has
a disply of the hyperlink of all the cells I mean any cell
linked with a path by hyperlink to the ceartain folder
as this \\servername\sharename\directory1\directory1
\filename.pdf
now what hapen is that the repeating of directory1
was happend and now all the links to files are not correct
as tha previous one .
the correct path is \\servername\sharename\directory1
\filename.pdf
now is there any way to delete the folder directory1 from
the path to all the cells which are a big number without
editing evreyone each .
second is there any way to make a new column that has the
hyperlinks pathes then to make replacement with find for
any word?
thanks alot for help.

 

[Don Guillett]

It is NOT necessary to post in ALL groups. ONE is enough. We read em all.

 

[Tom Ogilvy]

This question was already answered in another group yesterday. Why not find
the answer and if it doesn't provide the information you need, post the
reason why not. Stay in the original thread.