How to separate full name as first Name and Surname in MS-Excel using formula?

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

is step one

=RIGHT(A1,Jane(A1)-FIND(" ",A1,1))

is step two

Then copy and paste formula down.

Excel -2012,

Got to Data Ribbon - Text to column menu-delimited (finish the process)

Its very easy...Enjoy...

Thanks so much for your replies, i got the solution i.e. very similar to your repliesFirst Name =LEFT(A2,FIND(" ",A2)-1)Surname = =RIGHT(A2,LEN(A2)-FIND(" ",A2))

First Name Cell: =LEFT(A2, SEARCH(" ",A2,1))

Surname Cell:     =RIGHT(A2,LEN(A2)-SEARCH(" ",A2,1))

Fiest Name Cell: =LEFT(A2, SEARCH(" ",A2,1))

Surname Cell:     =RIGHT(A2,LEN(A2)-SEARCH(" ",A2,1))

More details on microsoft office support 

http://office.microsoft.com/en-001/excel-help/split-text-among-columns-by-using-functions-HA.aspx#BMex4