How do I remove a reference from a cell?

  • Thread starter stayathome working girl
  • Start date
S

stayathome working girl

I have a worksheet that has info that was ported from a pdf file. The cell
has a reference that would give additional info. I do not need it there.
How do I remove reference to additional info?
 
G

Gary''s Student

It depends on the nature of the reference. If the reference is a hyperlink,
then this tiny macro will remove it:

Sub format()
Selection.Hyperlinks.Delete
end sub

Just select the cell(s) and run the macro
 
Top