ColumnA, ColumnB
Last name, firstname
test, test1
bob, bob2

How do I get the above to show first name last name?

so far i've got:

=LEFT(A1, SEARCH(" ",A1,1))
=RIGHT(A1,LEN(A1)-SEARCH(" ",A1,1))

how ever it is showing the comma and I don't want that.