From within a single cells of text/numbers I need to extract only those numbers that are preceded by a ~ character and then sum them.
So as example, one such text formatted cell contains:

1991 SARW VIN #MG0910433R in 1982 Homemade Semi Trailer VIN #NEBR007742 ~30k; Trailer VIN #CLA1995W248T4112 ~10k; Trailer VIN #1024395 ~8k; Model #LS-4207, VIN #1C9GB42363G864016 ~15k

Result should be 63 (which was the sum of 30+10+8+15).

I'm really stuck on this one, so any help would be greatly appreciated!
FuzzyDove