Function for splitting a name to two cells from 1 input
 

In my data entry sheet I have a validated list of names
by first name. Is there a function that is able to split
the first and last name into seperate cells in my
database?

Function for splitting a name to two cells from 1 input
 

Hi
have a look at
http://www.cpearson.com/excel/FirstLast.htm

or you may use 'Data - Text to Columns' for splitting your data


--
Regards
Frank Kabel
Frankfurt, Germany

mymargherita wrote:
In my data entry sheet I have a validated list of names
by first name. Is there a function that is able to split
the first and last name into seperate cells in my
database?