Thread: Function for splitting a name to two cells from 1 input
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default 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?
Reply With QuoteReply With Quote