I have below range of Text Values - I wish to have a formula in Cell B85 as follows emtered with CSE to produce({}):
to get result of: 190.51
<tbody>
={SUM(LEFT(B72:B84,FIND(" ",B72:B84,1)-1)+0)}
But I'm Getting #VALUE !
How do I need to Adjust above existing Formula?
</tbody>
Excel 2010...