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