How does it mess you up? Show some sample code that causes a problem.

--
Regards,
Tom Ogilvy

"choice" wrote in message
...
i have:
='\\BACKRIGHTCOMP\T-Mobile\Choice\[Data.xls]Tracker'!C1497
and

='\\BACKRIGHTCOMP\T-Mobile\Choice\[Data.xls]Tracker'!C1497+'\\BACKRIGHTCOMP\
T-Mobile\Choice\[Tables.xls]new'!C1497

how can i do a find replace in order to just get
[workbook.xls]worksheet!cell
the thing that always messes me up is the apostrophe after the worksheet
name

thanks in advance