Eliminate hyperlinks

[Dale]

I have a rather large spreadsheet that I copy/pasted off the net. It's
test data on the students in my school. When I copied the info into
Excel, their names, headings, and data all come with hyperlinks that
lead me to this testing website. My question is this: Is it possible to
eliminate all these hyperlinks at one time and if so, how? Thanks. I'm
using Excel 2000 but can switch it to Excel XP (2003?)

Dale

 

[Peo Sjoblom]

One way, select an empty cell, copy it (ctrl + c), select the range with
hyperlinks (obviously not with the mouse) then do edit>paste special and
select add

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Guest]

Hi Dale!

Maybe you can try the ff
(1) Select all the data in the spreadsheet then copy the data (ctrl+c).
(2) Use the paste special function (values only). Go to edit then paste
special then select paste values then ok.

NOTE: If it does not work the way you've expected, you can use ctrl+z (undo)
to go back the way the data is first presented. You may want to also to
duplicate the page first just to make sure.

Hope this helps!

 

[Guest]

Modification to my earlier post...

(1) On a blank area/cell on your spreadsheet type/enter the value 1. If
there's no space available use a separate sheet (but on the same workbook).
(2) Right mouse click the entered value then select copy.
(3) Proceed to the range containing your hyperlinked data then select them
all.
(4) Right mouse click the highlighted data then select paste special then
operation then multiply.
(5) Select OK.

Hope this helps!

 

[dodong]

Use Excel Help, just type "Remove a hyperlink" this will gie you an
answer on how to remove all hyperlinks at one time.

 

[gjh3124]

Hi,

I have been using the free ASAP utilities for a while and they are
great! No, I am not the author!

Aside from removing hyperlinks, this addon contains a utility to
completely remove old macros from a file - a task I could not achieve
in Excel.

Have a look: http://www.asap-utilities.com/

Bye for now,

Geoff.