New to Excel 2007 and already extremely irritated.
I would like to find stuff within a formula and replace it with other stuff. I frequently did this in 2003 without issue. This is what I'm trying to do.
Problem #1
Select a range of cells with formulas
Example formula: =(-2/D4-E4)*F4-2*'Individual Scores'!B2
Find and Replace 2* with 2*$G$4
I receive the error message:
Your formula is missing a parenthesis . .. . . . . .
Problem#2
Select a range of cells with formulas
Example formula: =(-2/D4-E4)*F4-2*'Individual Scores'!B2
Find and Replace 2* with nothing (litereally nothing, not a string)
I receive the error message:
Your formula is incomplete. You must include and operand . . .
Is this due to the wildcard character searches (*,?) and me using a simple * instead of using Product(2,'Individual Scores'!B2) to multiply two values? If so is there a way to turn off wildcard character searching?
i.e. how and the heck would I find 2* and replace with product(2,'Individual Scores'!B2)
freakin' upgrades . . . .
Bookmarks