How to separate name and family in one row in excel to two rows?

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

RIGHT(A2,LEN(A2)-FIND(" ",A2))

Full name

Ist Name

Last Name

Balamurali Ramakrishnan

Balamurali

Ramakrishnan

Mohamed Ali

Mohamed

Ali

Raja Ram

Raja

Ram

Use the Text To Column Wizard, Got to:

Data → Data Tools → Text to Column

1- select (Delimited) if your Data is separated by Tap, Semicolon, Comma or Space and then click (NEXT)

2- in the second screen select Space [assuming you separate the names that way] and click Next.

3- in the third Screen Select (TEXT) as your Column Data Format.

4- Select your Out Destination.

*Note: if you did not select the Destination your Current Data well be replaced.

*Note: You can preview how the output of your Data well look like in Data Preview Window.

5- Click (Finish) To apply changes and exit the Wizard.