Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Find and replace results can the appearance of find be different? | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions |