View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin K Kevin K is offline
external usenet poster
 
Posts: 2
Default Take part data from two fields and auto fill into 3rd field

needing to know how to take pieces of data from other fields and auto fill
into a 3rd field. For example, field one is First Name, Field Two is Last
Name, Field three is first two digits of first name followed by first three
digits of last name. How can I automatically create a formula to have excel
create this for me?