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

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

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

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

"SodaFried" wrote in message
...
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

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

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

--


Regards,


Peo Sjoblom


"SodaFried" wrote in message
...
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

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

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

On Nov 5, 11:24*pm, 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

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

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