Hyperlinks not sorting in Excel

Status
Not open for further replies.
Aug 15, 2018
2
0
10
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!
 
Status
Not open for further replies.