Hi,

I have a data set that contains shipping information. The package details (number/weight/volume) are all contained in one cell. Is there a formula that will identify all of the weights and add them up?

For example: The below is from 1 cell and shows that there are 2 packages totaling 1217kgs (418kg+799kg). is there a formula that will just identify the 2 weights an total them?
1 PKG | 418 Kg | 0.509 m3 | 1 PKG | 799 Kg | 0.691 m3

Thanks,
Banno123