View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KB916521 Junk Update Office 2003 -A  KB916521 Junk Update Office 2003 -A is offline
external usenet poster
 
Posts: 1
Default extract first name only from full name

I have a cell that contains last name, first name. I would like to extract
the first name and put in seperate cell. As an example if A1 = Smith John I
would like to have A2 = John and A3 = Smith Please advise.