How do I get rid of a series of hyperlinks in a column or row

  • Thread starter Thread starter SodaFried
  • Start date Start date
S

SodaFried

How to I get rid of a series of hyperlinks in a column or row with embedded
pictures or graphics leaving the text behind? I only want the text or numbers
left on spreadsheet.

The instructions only cover a single hyperlink and are vague from there on
and require multiple steps.
 
If you mean what I think you mean, have you tried cut followed by paste
special, values. And in future use paste special when first copying the into
the sheet.

V
 
Copy an empty cell, select the range of hyperlinks, paste special and select
add

--


Regards,


Peo Sjoblom
 
Select the range with the hyperlinks in, press Alt-F11 to bring up the
VB Editor, then CTRL-G to enter the Immediate Window, and type this:

Selection.hyperlinks.delete

followed by <Enter>.

Close the VB Editor window to get back to the worksheet.

Hope this helps.

Pete
 
Back
Top