find and replace
i have:
='\\BACKRIGHTCOMP\T-Mobile\Choice\[Data.xls]Tracker'!C1497
an
='\\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
|