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

[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.

 

[Victor Delta]

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

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[Pete_UK]

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

 

[FSt1]

hi
paste this into a standard module. high the hyperlinks and run.
it will remove on the the hyperlinks, leaving the text.
Sub removehyperlink()
Selection.Hyperlinks.Delete
End Sub

if you are new to macros, see this site
http://www.mvps.org/dmcritchie/excel/getstarted.htm

regards
FSt1