Rplace part of formula

nmrosen

Board Regular
Joined
May 20, 2003
Messages
115
I have a large spreadsheet in which every cell in it has a formula that is similar to = .4*A1 + P6/F7

I would like to replace .4 with .35 globally in every cell. When I try to use replace, i only get error messages. Is there some way to use the replace menu item to get this done?
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

nmrosen

Board Regular
Joined
May 20, 2003
Messages
115
thank you

thank you, that does work. Why? what is the function i=of the "~"?
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
the tilde "~" is used in front of the wild card characters (* & ?) so that Excel recoginizes that you want the literal use not the wild card use
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
try this
find = .4~*
replace = .35*

I tested and it worked

A SOX-compliant suggestion...

Insert a new sheet, name it Admin.

In A2 enter: Multiplier
In B2 enter: 0.35
Select B2 and assign it Multiplier as name via the Name Box.

Run the procedure Alynn suggests:

find = .4~*
replace = Multiplier*

or

find = .35~*
replace = Multiplier*
 

Forum statistics

Threads
1,171,269
Messages
5,874,748
Members
433,070
Latest member
omartarek

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top