View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
krc547 krc547 is offline
external usenet poster
 
Posts: 28
Default Pulling only first name

I need to pull the first names and first initial of last name into a cell. In
cell g I have the first and last name (john doe). I need cell c to look at
cell g nad return only john d.