Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Samer Harb , Food Consultant , Free Lance
Date Posted: 2015/03/31
Balamurali Ramakrishnan
by Balamurali Ramakrishnan , Service Asset & Configuration Analyst , UST Global

 

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

 

 

 

Fares Basnawi
by Fares Basnawi , Assistance Maintenance Planning Manager , AFIA International Company

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.  

 

More Questions Like This