Edit the hyperlink address from UNC path to drive letter

[itsjamaal]

I have 550 lines in my excel file, all are hyperlinks
All are using UNC path as hyperlink address, I want to change it to a drive letter.
How to replace all the lines at one go.
Please guide
HyperLink Address : "\\myserver\mydatas\sub-folder\
Needed Change : \\S:\sub-folder\

[ranman256]

Use the UNC, you should never use drive letters.

[itsjamaal]

UNC's path keeps changing
so please guide me to change as a drive letter.

Else tell me how can I change all the hyperlinks, while my UNC path changes.