In column A1:A500 I have a formulas in each cell. I want to change the relative cell reference for one component in each cell in the column. I cannot use a simple EDIT--->REPLACE ALL to do the job, as there is no single unique qualifier to lookup each formula to make the correct change.
Is it possible to use "wild cards" in the EDIT- --> REPLACE ALL feature of excel 2003?
For instance lets say in cell A3 the formual is B3*C3. But I want to change it to: B3*$C3
In cell A4 the formula is B4*D4. But I want to change it to: B4*$D4
(note: this is a very simplified example)
Is there a way to use a wild card in the EDITt-->REPLACE ALLl feature such as this:
FIND: "L#*L#" (i.e. B4*D4)
REPLACE WITH: "L#*$L#" (i.e. B4*$C4)
In this example, I used "L" to denote a "letter character", and a "#" to denote a number in the formula.
thanks
Start Free Trial
