How do I remove a reference from a cell?
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
--
Gary's Student
"stayathome working girl" wrote:
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?
|