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.