Wildcard in the Replace function
"Jacob Skaria" wrote:
Do you mean to replace *14 to *20. Try the below..Make sure from Find and
replaceoptionsLookin 'formulas' is selected
Find what
~*14
Replace with
*20
If this post helps click Yes
---------------
Jacob Skaria
"User 100" wrote:
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?
I always like to include some of the text string in the find. There could be a 20 at the beginning of the formula that I do not want changed. By listing CustList, it ensures that the correct part is replaced. I was hoping that this would have been addressed in Excel 2007.
|