Assume the list starts in A2, in B2

=--LEFT(A2,FIND(" ",A2)-1)

copy down

WoW! It works like a charm.
However I couldn't figure out why it works.
I understand you use "FIND(" ",A2)-1" to locate the position of space.
But why does it work to remove extra "0"?
It seems to do with the 2 magic "minus".

(I still figuring out the rest of your codes!
I'll have another reply soon.)

Best