Hi All
I've copied 2 x columns x 760 rows of data from a web site and pasted to a new workbook. The data in column 1 are all sequential numbers for fault codes and each has a hyperlink. How can I remove all the hyperlinks, as I only require the number. I've tried pasting as text, but then I lose the columns.
Thanks Simon
Hi,
I have an Excel column with e-mails but they are hyperlinked.
So, I cannot edit them because it opens my e-mail server.
How can I remove the hyperlinks?
SantistaS
hey.
my team is using a shared spreadsheet with loads an loads of hyperlinks to a different spreadsheet that i'm somehow unable to remove.
when you right-click, the "delete hyperlink" & "edit hyperlink" option is greyed out, only "open hyperlink" is available. when you click "open" you get the error message: Unable to open, as the file it links to doesn't exist anymore.
the spreadsheet is not protected as far as i can see either...
i tried to delete & paste special (value only). but it doesn't affect the hyperlink at all
any ideas? thanks!
I have an exported file with more than 100 hyperlinks. How can i remove the hyperlink (en mass) without disrupting the format of the spreadsheet?
Excel XP, Win XP
I have a list of hundreds of hyperlinked cells scattered throughout more
hundreds of non-hyperlinked cells. I want to remove the hyperlinks. What
is the code query for a hyperlinked cell?
Something like:
If ActiveCell....hyperlink...=True Then
Thanks for your time. Otto
I have a list of thousands of names with emails. The email shown in the cell is accurate but when I click on it I get a hyperlink to a differnet email. How do I do a mass change to remove all the hyperlinks in that column?
Hi Everyone,
Is it possible to create a macro, which removes several /all/ hyperlinks, or according to prevously selected cells?
Thank you in advance!
An outside application exports data to an Excel spreadsheet, but all the
numbers (part numbers in this case) are created as hyperlinks. My
spreadsheet can contain hundreds of numbers. Is there any way I can remove
the hyperlinks en masse rather than one by one? I can't change the program
that creates the spreadsheet.
Thanks,
Dave
Hello,
how can i remove all Hyperlinks in every single cells at once in a column?
Greets
Thanks in advance
Okay, I have an easy one.
I have 35 e mail addresses. How can remove the hyperlink property but leave the address? I can remove one hyperlink at a time but that will take a long time.
Is there a difference on this between 2002 and 2000?
Thanks
Berg
