First & last name in one column to 2 columns

[tlang]

I am needing help with first & last name in one column to 2 columns. What is the function or formula?

 

[Aladin Akyurek]

I am needing help with first & last name in one column to 2 columns. What is the function or formula?

Have you considered using Data | Text to Columns?

 

[tlang]

I have 400 names, is there an easier way with a formula or function?

 

[Smitty]

Welcome to the Board!

Data-->Text to Columns is about as easy as it gets. Have you tried it? Just make sure to do it on a copy of your data first.

 

[adamthompson3232]

You can also use this formula in a column next to your data:

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

The formula above should give you the first name.

Then use this formula to get the last name in another column next to the first name column.

=RIGHT(A1,SEARCH(" ".A1)

 

[Maheshp]

Hi
hope this will help !
http://www.mrexcel.com/forum/showthread.php?t=549864