Calc: how do I get rid of just a hyperlink

I have two cells with hyperlinks in them somehow. I want to leave all other formatting in tact but remove just the hyperlinks. The text of the hyperlink needs to remain.

Also, in the format menus is there a way to tell certain cells to NEVER insert a hyperlink?

Many thanks,
-T

Select the cell (s), choose Format>Delete Direct Formatting from the menu.

But you have to put everything back if you do that.

Why is this answer marked/checked correct then?

I copied the link to a text editor, erased the link, pasted the text back with shift ctrl v

Never did figure out how to turn them off completely