Removing hyperlinks in bulk

A worksheet I prepared contains a lot of hyperlinks. (I pasted some
cells in from a web site.) I can see how to remove each one
individually with R-click > Hyperlink > Remove Hyperlink. But so far
haven't found a way to do it for an entire column, or the whole sheet.

Working with the sheet is awkward, as I often inadvertently open a
link in my browser when all I want to do is copy the text in that
cell.

--
Terry, West Sussex, UK

copy the range you just pasted, and paste it again to another location (like another sheet) using "paste special, values".

Select any blank cell and "Copy" it. Then select all of your hyperlinks that
you want to replace (or columns, or worksheet). Then select "Paste Special".
Under the "Operations" section, select "Add". That should do it.


"Terry Pinnell" wrote:

> A worksheet I prepared contains a lot of hyperlinks. (I pasted some
> cells in from a web site.) I can see how to remove each one
> individually with R-click > Hyperlink > Remove Hyperlink. But so far
> haven't found a way to do it for an entire column, or the whole sheet.
>
> Working with the sheet is awkward, as I often inadvertently open a
> link in my browser when all I want to do is copy the text in that
> cell.
>
> --
> Terry, West Sussex, UK
>

See

http://www.mcgimpsey.com/excel/nohyperlinks.html

In article <[email protected]>,
Terry Pinnell <[email protected]> wrote:

> A worksheet I prepared contains a lot of hyperlinks. (I pasted some
> cells in from a web site.) I can see how to remove each one
> individually with R-click > Hyperlink > Remove Hyperlink. But so far
> haven't found a way to do it for an entire column, or the whole sheet.
>
> Working with the sheet is awkward, as I often inadvertently open a
> link in my browser when all I want to do is copy the text in that
> cell.

"Elkar" <[email protected]> wrote:

>Select any blank cell and "Copy" it. Then select all of your hyperlinks that
>you want to replace (or columns, or worksheet). Then select "Paste Special".
> Under the "Operations" section, select "Add". That should do it.

Thanks. Looked neat, but didn't work!

--
Terry, West Sussex, UK

i-Zapp <[email protected]> wrote:

>
>copy the range you just pasted, and paste it again to another location
>(like another sheet) using "paste special, values".

Excellent, thanks. Seems to work a treat.

--
Terry, West Sussex, UK

JE McGimpsey <[email protected]> wrote:

>See
>
> http://www.mcgimpsey.com/excel/nohyperlinks.html

Thanks. Might try the first macro out of curiosity (and to refresh my
skills in how to install macros anyway <g>), but that Paste Special >
Values method from i-Zapp looks simpler!

--
Terry, West Sussex, UK