| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find and replace
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find and replace
it will give an error saying function is not correct when it goes to the next
function well i was just doing a find "'\\BACKRIGHTCOMP\T-Mobile\Choice\[Data.xls]Tracker'! and replace with [data.xls]tracker!, but some equations have multiple sheets and workbooks so i guess my question is, is there a way to do a find and replace that will work for '\\BACKRIGHTCOMP\T-Mobile\Choice\[Data.xls]Tracker'! and '\\BACKRIGHTCOMP\T-Mobile\Choice\[Tables.xls]new'!C1497 is there like a wildcard function that will allow me to replace everything inbetween ' and [ and also the value before ! "Tom Ogilvy" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find and replace
No, if you are replacing a substring, I think you need to know what it is.
There may be special cases where you can do that, but I don't think there is any way you can do Replace: '*' With: 'Some String' -- Regards, Tom Ogilvy "choice" wrote in message ... it will give an error saying function is not correct when it goes to the next function well i was just doing a find "'\\BACKRIGHTCOMP\T-Mobile\Choice\[Data.xls]Tracker'! and replace with [data.xls]tracker!, but some equations have multiple sheets and workbooks so i guess my question is, is there a way to do a find and replace that will work for '\\BACKRIGHTCOMP\T-Mobile\Choice\[Data.xls]Tracker'! and '\\BACKRIGHTCOMP\T-Mobile\Choice\[Tables.xls]new'!C1497 is there like a wildcard function that will allow me to replace everything inbetween ' and [ and also the value before ! "Tom Ogilvy" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find and replace
any suggestions as to what would be the best way to get:
='\\BACKRIGHTCOMP\T-Mobile\Choice\[Data.xls]Tracker'!C1497+'\\BACKRIGHTCOMP\T-Mobile\Choice\[Tables.xls]new'!C1497 to turn into: =[Data.xls]Tracker!C1497+[Tables.xls]new!C1497 "Tom Ogilvy" wrote: No, if you are replacing a substring, I think you need to know what it is. There may be special cases where you can do that, but I don't think there is any way you can do Replace: '*' With: 'Some String' -- Regards, Tom Ogilvy "choice" wrote in message ... it will give an error saying function is not correct when it goes to the next function well i was just doing a find "'\\BACKRIGHTCOMP\T-Mobile\Choice\[Data.xls]Tracker'! and replace with [data.xls]tracker!, but some equations have multiple sheets and workbooks so i guess my question is, is there a way to do a find and replace that will work for '\\BACKRIGHTCOMP\T-Mobile\Choice\[Data.xls]Tracker'! and '\\BACKRIGHTCOMP\T-Mobile\Choice\[Tables.xls]new'!C1497 is there like a wildcard function that will allow me to replace everything inbetween ' and [ and also the value before ! "Tom Ogilvy" wrote: 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 |
| Reply |
| 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 | |||
![choice[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
