Permanently remove multiple Hyperlinks in Numbers

How do you select multiple email different email addresses in a column and remove hyperlinks from all of them? I have googled for ages and cannot find out how to do this.

There is already this thread here: Permanently removing hyperlinks in Number… - Apple Community

But it doesnt work - if you use paste and replace it copies whatever email is on the clipboard to ALL the cells. I can only change one at at time by selecting the text in a given cell and then changing the 'link' option in the Format sidebar.

So how do you remove all the hyperlinks in different email addresses in a single column?

PS the preference to untick in Settings doesnt work either - all my boxes in that area are unticked and email addresses are still annoyingly active and turn a click into writing an email