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
"SodaFried" wrote:
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.
--
Howdy