Wildcard in the Replace function

U

User 100

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?
 
J

Jacob Skaria

Do you mean to replace *14 to *20. Try the below..Make sure from Find and
replace>options>Lookin 'formulas' is selected

Find what
~*14

Replace with
*20


If this post helps click Yes
 
U

User 100

Jacob Skaria said:
Do you mean to replace *14 to *20. Try the below..Make sure from Find and
replace>options>Lookin 'formulas' is selected

Find what
~*14

Replace with
*20


If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top