Register now or log in to join your professional community.
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.