Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove a reference from a cell?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
substitute the filename in a cell reference with a string in another cell. | Excel Discussion (Misc queries) | |||
How do I create a cell reference from a value within a cell? | Excel Worksheet Functions | |||
Bring the cell format along with the cell value from a reference c | Excel Worksheet Functions | |||
Getting contents of a cell when cell reference is in the sheet | Excel Discussion (Misc queries) | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |