Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there a way to natively use wildcards in Find & Replace, in Excel 2010? I'd rather not install an add-on if it can be avoided.

For example: I want to be able to use a syntax similar to the following, in the Find & Replace dialog:

  • FIND: =IF(SUM(*)=0,"",SUM(*))
  • REPLACE: =SUM(*)

This should find a formula such as =IF(SUM(A1:A10)=0,"",SUM(A1:A10)) and replace it with =SUM(A1:A10).

share|improve this question

1 Answer 1

You can use a question mark as a wildcard in a Find or Find & Replace. If there are multiple wildcards in a row, use question mark + asterisk:

=IF(SUM(?*)=0,"",SUM(?*))

In the example above you're searching formulas, not values, so make sure you expand the Find dialog box by clicking on the "Options" button in the bottom right, and select "Formulas" in the "Look In" dropdown. Hope this helps!

Edit: This won't work for replace the way you've described. I'm not sure there's a way to do that with Find & Replace. You could do it with a VBA script though.

-- jm

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.