Hyperlinks change during sort
 

One of the columns in my spreadsheet contains hyperlinks to files of the same
name.

When I sort on another column, the hyperlinks no longer match the displayed
text.

How do I sort a spreadsheet without losing the correct hyperlinks?
--
Richard