Rplace part of formula

texasalynn

Well-known Member

Joined

May 19, 2002

Messages

8,458

• Oct 3, 2006

• #2

try this
find = .4~*
replace = .35*

I tested and it worked

 

Upvote 0

N

nmrosen

Board Regular

Joined

May 20, 2003

Messages

115

• Oct 3, 2006

• #3

thank you

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

 

Upvote 0

texasalynn

Well-known Member

Joined

May 19, 2002

Messages

8,458

• Oct 3, 2006

• #4

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

 

Upvote 0

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Oct 3, 2006

• #5

try this
find = .4~*
replace = .35*

I tested and it worked

Click to expand...

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*

 

Upvote 0

texasalynn

Well-known Member

Joined

May 19, 2002

Messages

8,458

• Oct 3, 2006

• #6

A SOX-compliant suggestion...

Click to expand...

you mean they have SOX in the Hauge?

 

Upvote 0

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Oct 3, 2006

• #7

A SOX-compliant suggestion...

Click to expand...

you mean they have SOX in the Hauge?

Click to expand...

Sure. BTW, my teaching has always been: "No constants in the formulas." Even started to avoid VLOOKUP where the index of the return range is a constant.

 

Upvote 0