>>Hi everybody,
>>
>>Do you know how can I remove hyperlink from all entries in the column? I found a way to do it per each cell, but I need to do it for the whole column.
>>
>>Thanks a lot in advance.
>
>First turn off the auto correct feature that creates the hyperlinks.
>Tools Menu, Options, Spelling Tab, Auto Correct Options button,
>AutoFormat as you type tab, uncheck Internet and network path with hyperlinks.
>
>Close the spreadsheet and reopen it so the change is in effect.
>
>Copy the cells, then paste special, select values. That should do it.

I copied these cells to another column, then copy back using paste special/values. This worked. I'm not sure, auto-format helped in any way.

Thanks a lot.