Thanks chrome....i am new at excel and wanted see if what i was doing to extract information was correct....and it was according to your file....i also use this formula to extract information from cyber horse form

=TRIM(MID(A$2,FIND("&",SUBSTITUTE(A$2,",","&",B2))+1,FIND(",",REPLACE(A$2,1,FIND("&",SUBSTITUTE(A$2,",","&",B2)),""))-1))


where B2 has the amount of commas that you want to skip to and A2 contains the form line