Hi,

Is it possible to sum values within one cell of Excel. I appreciate its probably not good practice BUT its an export from a 3rd party application and rather having to juggle the data a sum from that single cell would be ideal?

Example: A1 - 0.1, 1.5, '0.5, '1.2 B2 - Sum of A1 (excluding the ' and ,)

Cheers