Removing multiple hyperlinks

R

rlst8bobbi

I've got data copied into my spreadsheet that includes hyperlinks. Ther
are thousands of these in a column.

I can remove individually by right-clicking and selecting Hyperlink an
Remove. I can then arrow down and do a control Y, cell by cell,

What I want to do is highlight the column and be able tp remove th
hyperlinks all at once.

I've exhausted myself peering through knowlegebases and groups, bu
cannot find any way to make this work.

Thanks for any input you can provide
 
F

Frank Kabel

Hi
one way:
Use the following macro to remove hyperlinks of a chosen selection
(after your data entry)
Sub RemoveHyperLinks()
selection.hyperlinks.delete
end sub
 
Top