Remove Hyperlink

**WCAR7265** · 09-09-2008, 10:54 AM

How do you remove the hyperlink from a column of email addresses or website addresses?

**martindwilson** · 09-09-2008, 10:58 AM

Please Login or Register  to view this content.

put in a standard module sellect all the cels you want in column
tools/macrs/run macro "removehyperlinks"

**Richard Schollar** · 09-09-2008, 11:08 AM

Or:

Please Login or Register  to view this content.

Richard

**sglife** · 09-09-2008, 09:50 PM

If there are not any formulas linked to this column, and you don't want to use VBA mathod.
Try this simple way

Add a column next to the hyperlinked one, say A
Copy the whole column,
select the new column, paste special > Value
Delete column A
Maybe you need to paste special > format before you delete A