Extract only numbers from one cell to another page?

I have a spreadsheet I finally have automated, but the last page. It calls from another page, that is a call from yet another page, so I can't just search and replace.

The current formula in cell A4 is =IF(INDEX(HVY!A:A,3)<=0,"NONE",INDEX(HVY!A:A,3))

That spits out something that looks like "0000000 Total"
I want it to just be the numbers, and remove the "Total"

is there a way to do this?

Also, this is on Excel 03

=SUBSTITUTE(IF(INDEX(HVY!A:A,3)<=0,"NONE",INDEX(HVY!A:A,3)),"Total","")

Maybe this ...

Formula:

Please Login or Register  to view this content.

Or, it seems to me at least, that you don't need INDEX()

Formula:

Please Login or Register  to view this content.