HOW TO EXTRACT STRINGS FROM CELLS

[Guest]

hello
i have an excell file with abt 100 records.
one of the columns is of names. now i want that ´the first name and the
last name should appear in different cells. what will b the formula to get
the first n last names in two different columns depending on a blank space
which separates them in the existing same coloumn of names
thanking in advance

 

[Niek Otten]

Menu:
Data>Text to Columns

 

[Bob Phillips]

=LEFT(A1,FIND(" ",A1)-1)
and
=RIGHT(A1,LEN(A1)-FIND(" ",A1))

or else you could use Data>Text To columns with a space separator

--

HTH

RP
(remove nothere from the email address if mailing direct)