Hi, I have mutiple numbers in one cell that I would like to be added together into the column beside it.
eg H32
24.00 12.00 24.00 12.00 12.00

they all seem to be seperated by either 6 or 7 spaces.

Can someone please help me out with a formula for this?

Thanks