Possible to use wildcards in replace?

[cr731]

Is it possible to use a wildcard in the replace formula? For instance, I have a variance formula in about 20 tabs, calculating like this:

E9 - F9
E10 - F10
E11 - F11

And so forth down the column. However, I've realized that it should be F9 - E9 instead. Is there a quick way to replace all of these in the formula? Basically I'm asking if it is possible to do something like this:

Find: E? - F?
Replace with: F? - E?

Where it will just keep whatever the ? is in the formula?

Or is there a different way?

 

[danzon]

highlight the column and do a find replace on F... changing to say Z
then do the same changing E to F
then change Z to E


ooops... just realized you need to do this across multiple tabs... Sure a VB pro will offer a quick VB solution

 

[cr731]

highlight the column and do a find replace on F... changing to say Z
then do the same changing E to F
then change Z to E


ooops... just realized you need to do this across multiple tabs... Sure a VB pro will offer a quick VB solution

Yeah at first I thought something like that could work as well, except that I obviously don't want to replace all F's in the workbook, and I can't use the "match entire cell contents" option since there is more to the formula.