This is one of many links that were created when opening an excel file from
Lotus Notes.

'H:\DOCUME~1\sconklin\LOCALS~1\Temp\notesFFF692\[~5020587.xls]Aug 2
Pivot'!Z1432

The "linked" file no longer exists. (I don't "update", so the data remains
the same)

I want to keep the cell references (in this case, Aug 2 Pivot'!Z1432), but I
want to delete the rest
(H:\DOCUME~1\sconklin\LOCALS~1\Temp\notesFFF692\[~5020587.xls])

To make the changes all at once I tried doing "Find and Replace" on
H:\DOCUME~1\sconklin\LOCALS~1\Temp\notesFFF692\[~5020587.xls], hoping to
replace with "" {blank}, but it doesn't seem to be able to "find" this
string...I'm guessing because of the tildes?

Any suggestions?

Thanks