How do I remove multiple hyperlinks in the same cell (Excel)?
 

I have multiple hyperlinks in one Excel cell, each separated by a hard return
(ALT-Enter). I can remove the hyperlinks using:

-- right click remove hyperlink
-- or by using a macro

but I cannot get this to work on multiple links in one cell. When I do
this, all links go into one line separated by a square box.

I have had to create a separate line for the second hyperlink, and this is
making my spreadsheet look out of alignment.

Please help!