Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have several formulas that I would like to do an edit and replace on. I
would like to be able to use a wildcard for part of the formula but I'm not sure how to do it. Here is an example of what I need to change: Change 02 Feb\[OAKL 0209.xls] to 03 Mar\[OAKL 0309.xls] Change 02 Feb\[CEDA 0209.xls] to 03 Mar\[CEDA 0309.xls] I have several other similar formulas that are within the same spreadsheet. I would like to be able to do some kind of wildcard on the four characters before the "0209.xls" so that I could do an edit and replace on all of them at the same time. I tried inserting astrisks 02 Feb\[**** 0209.xls] and change it to 03 Mar\[**** 0309.xls] but that didn't work. Any help would be appreciated. AJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and Replace with wildcards? | Excel Discussion (Misc queries) | |||
Why not accept wildcards for REPLACE as well as FIND ? | Excel Discussion (Misc queries) | |||
Replace using Wildcards | Excel Worksheet Functions | |||
use replace to edit a formula with wildcards | Excel Worksheet Functions | |||
Replace using wildcards | Excel Discussion (Misc queries) |