>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.
___________________________
Kenneth Wonderley
http://www.wonderley.com...the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness and self-control.
Galatians 5:22 & 23