removing more than one hyperlink

D

dkb43

I have an import into Excel that involves 1000 records. Each record has one
important field has a hyperlink, thus 1000 hyperlinks. In Excel 2000, how do
I remove the hyperlinks. Right now the only method I can find is to remove 1
hyperlink, then move with the down arrow and use F4. Twenty records might
work fine that way, but 1000 is way too many.

Thanks!
Deb
 
F

FSt1

hi
high light the field and run this macro...
Sub removehyperlink()
Selection.Hyperlinks.Delete
End Sub

regards
FSt1
 
H

Hardeep_kanwar

1:put 1 in any blank Cell copy the cell.Select the Column.Then go to
Edit<Paste Special<Click Multiply <OK.

2: Ctrl +A Twice Alt +F11< Ctrl +G
Type: Selection.hyperlinks.delete

Then Enter

Press Alt+Q to Return to Excel

Hardeep kanwar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink list in excel 1
removing hyperlinks 1
How to prevent email addresses from becoming hyperlinks, and removinghyperlink 1
update hyperlink values but not displayed text 1
Removing records using anther spreadsheet 3
How to Sort by Count the Max nos of Unique text values in Pivot Ta 1
Hyperlink won't open any other XLS file 2
Remove hyperlink, web link, and using Advanced filter 1

Top