Hi Andy,
If it's always 3 5-digit numbers:
=SUM(LEFT(A1,5),MID(A1,7,5),RIGHT(A1,5))
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Andy Brown" wrote in message
...
If I have "0.120;0.140;0.200" in a cell, is it possible to get the sum of
the values with a formula (NB: not code)?
=INDIRECT("="&SUBSTITUTE(A1,";","+")) just equals #REF!
TIA,
Andy
|