Column A Column B (return)
WindowsDevice 5.1.478 Windows
Symbole 5.2.0 Symbole
Symbole Symbole
BloomBerry 7.0.0 Bloom
Banan 4.0.1 Banan


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

=LEFT(A2,FIND(" ",A2))&MID(A2,FIND(" ",A2)+1,0)

I have tried both formulas, but do not work in all cells, specially on this line Symbole Symbole

Could some one came up with a formula please?