HOW TO EXTRACT STRINGS FROM CELLS
 

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

HOW TO EXTRACT STRINGS FROM CELLS
 

Menu:
DataText to Columns

--
Kind regards,

Niek Otten

"vidhya" wrote in message
...
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

HOW TO EXTRACT STRINGS FROM CELLS
 

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

or else you could use DataText To columns with a space separator

--

HTH

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


"vidhya" wrote in message
...
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