Globally replacing *

[Guest]

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.

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Pete_UK]

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