CODEWITHSUNDEEP
vbaexcel
Kelbe
Kelbe

Reputation: 161

Excel using Replace on Formulas

I have a bunch of formulas all over different rows and columns in my Excel sheet. Some of the formulas are of the form: =($B$12-G12)*$B$3*G3

All I want to do is replace the ")" with ")^2". I tried using the Ctrl + F -> Replace section to look in Formulas but for some reason Excel says cannot find a match...All the cells I am trying to replace are of the form:

=(Cell1-Cell2)*Cell 3*Cell4

I just want to replace that )* by ^2*

What can I do?

This is what I have tried searching:

enter image description here

Upvotes: 1

Views: 116

Answers (3)

Gary's Student
Gary's Student

Reputation: 96753

Make sure the Look in option is set to Formulas:

enter image description here

EDIT#1:

As per your comment, you must use tilda in the Find string:

enter image description here

Upvotes: 2

Grade 'Eh' Bacon
Grade 'Eh' Bacon

Reputation: 3823

In summary of the article I left as a comment (http://www.mrexcel.com/archive/General/29013.html), you need to use ~ [the character to the left of the 1 on a standard English QWERTY keyboard] before *, in order to specifically tell excel that you want to look for an asterisk, not use the asterisk as a wildcard.

Upvotes: 0

Kelbe
Kelbe

Reputation: 161

Find and search using:

)~*

What I was having difficulty with was the * and I found the solution is to just use a ~ and it will fix the problem.

Upvotes: 1

Related Questions