Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wildcard in the Replace function
This is a general question on the replace function. In the Find/Replace
dialog box, you can use wildcards to find text/formulas. There is not the same capability to use it in the replace function. I would like the wildcard to act as a placeholder. When I do the replace, I like to include some of the text string to ensure that the correct part of the formula is changed. So here is an example. The cell references are in brackets. '=CustList$B14(B4) =CustList$C14 (C4) =CustList$D14 (D4) In the replace part: '=CustList$*20 The "*" would leave the current column references in place and change the 14 to 20. Does Microsoft have plans to add this feature? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use of Wildcard characters with replace | Excel Discussion (Misc queries) | |||
Doing a replace with a wildcard charcter | Excel Discussion (Misc queries) | |||
replace using wildcard, or else | Excel Discussion (Misc queries) | |||
find & replace - digit wildcard | Excel Discussion (Misc queries) | |||
Find Replace Wildcard | New Users to Excel |