UDF or Button

[bsneils]

I have this equation:

=TEXT(SUM(LEFT(A1:A3,FIND(" ",A1:A3)-1)+0),"0.00")&" in"

(CTRL + Shift + Enter)

Is there a way to create a UDF for this using VBA or create a button on the Excel Toolbar that will perform this function.

Thanks

 

[Andrew Poulsom]

Would a normal (non-array) formula suit you?

=TEXT(SUMPRODUCT(LEFT(A1:A3,FIND(" ",A1:A3)-1)+0),"0.00")&" in"