how do i separate 2 strings of a cell in different cells?

B

Bona

I have names and surnames both in a single cell?
I want to separate them in different cells.
 
T

Toppers

Assuming names separated by a blank only one forename plus surname):


=TRIM(LEFT(A1,FIND(" ",A1)-1))


=TRIM(MID(A1,FIND(" ",A1)+1,255))

HTH
 
Top