Hyperlinks not sorting in Excel

[nadine.sabulsky]

I have created a spreadsheet and am putting multiple hyperlinks to various websites in each cell. The problem is, when I sort by column, the hyperlinks appear to stay in the same location, even though the cell data has changed. Example: in A3 the cell content is *Word* and hyperlink *http/example .com* but when I sort by a different column then the hyperlink stays in cell A3 but the data content is now *Word7*

Please help!

 

[rgd1101]

include the column on the sort

 

[nadine.sabulsky]

Apparently it's because I copied and pasted cells, and this is a known issue which Microsoft says can only be fixed by manually redoing each hyperlink!

OMG!

Microsoft sucks

https/support.microsoft.com/en-us/help/214328/hyperlinks-are-removed-or-invalid-after-you-sort-cells-that-contain-th