View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
User 100 User 100 is offline
external usenet poster
 
Posts: 2
Default 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?