Globally replacing *
 

Is simple way to do a global replace * (as an asterisk not a wildcard)? For
example how would I strip out the *100 from the following which is in
multiple cells on a sheet

SUM('Total Volume'!B5:M5)*100

Many thanks in advance for your help.

Globally replacing *
 

Use the tidle symbol ~ as in

Replace what:
~*100
Replace with:

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Bowler" wrote in message
...
Is simple way to do a global replace * (as an asterisk not a wildcard)?
For
example how would I strip out the *100 from the following which is in
multiple cells on a sheet

SUM('Total Volume'!B5:M5)*100

Many thanks in advance for your help.

Globally replacing *
 

As * can be used as a wildcard, you need to use ~* in a Find & replace
operation, so I would suggest:

Find What: ~*100
Replace with: <leave blank
Replace All

Another way in this particular case would be to replace 100 with 1.

Hope this helps.

Pete

On Nov 6, 10:20 am, Bowler wrote:
Is simple way to do a global replace * (as an asterisk not a wildcard)? For
example how would I strip out the *100 from the following which is in
multiple cells on a sheet

SUM('Total Volume'!B5:M5)*100

Many thanks in advance for your help.