Help with Left function

A B
1 10155.01299 10155.01299 7.50X27.50X1
2 #VALUE! 10255.01816
3 #VALUE! 10255.01820
4 #VALUE! 10255.01830

In cell A1 there is the formula =LEFT(B2,FIND(" ",B2)-1) Which returns the value I want from the combined value in B1. However the same formula in cell A2 returns a #value!. Is there a formula that could be used in A1-A4 that would return the first part number in B1 and the remaining part number in B2-B4?
So the result would be

A B
1 10155.01299 10155.01299 7.50X27.50X1
2 10255.01816 10255.01816
3 10255.01820 10255.01820
4 10255.01830 10255.01830