We help IT Professionals succeed at work.
Get Started

Excel - How to Remove Hyperlink Sprites (Image Elements)

259 Views
Last Modified: 2015-03-27
Excel 2013
Windows 7

BACKGROUND: When I copied some data from a web page, one column has intermittent hyperlinks that appear as a small image of a magnifying glass.

When you RIGHT CLICK the mouse on one of them, the context menu gives the option to remove hyperlink or cut (and others). When I select the entire column and delete, the column is deleted but the sprites remain, but they now appear superimposed over the data in what used to be the adjacent column.

QUESTION: Since there are hundreds of these, I need a formula or macro way to remove them all from the original column. There is no other data in the original column to worry about.

By the way, what do you officially call these "sprites"? I've seen them before, and sometimes they are invisible where you can only find them by hovering your mouse around until the cursor turns to the hand pointer.
Comment
Watch Question
CERTIFIED EXPERT
Top Expert 2016
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE