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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

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,209

ADVERTISEMENT

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,136,925
Messages
5,678,602
Members
419,774
Latest member
MooseWinooski

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