Formula too long error in excel for OSX

[rccommando]

Hi, I need a way to get around this error because I need this formula to work in the next few days. The formula is as follows:

=CONCATENATE(LEFT(B11,FIND(",",B11,1)-1),", ",IF(ISERROR(FIND(MID(B11,FIND(",",B11,1)+2,FIND(",",B11,FIND(",",B11,1)+1)-FIND(",",B11,1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,1)+2,FIND(",",B11,FIND(",",B11,1)+1)-FIND(",",B11,1)-2),1)),2,5)),B16,1)),"",MID(B11,FIND(",",B11,1)+2,FIND(",",B11,FIND(",",B11,1)+1)-FIND(",",B11,1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,1)+2,FIND(",",B11,FIND(",",B11,1)+1)-FIND(",",B11,1)-2),1)),2,5))),IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,1)+2,FIND(",",B11,FIND(",",B11,1)+1)-FIND(",",B11,1)-2),1)),"",IF(ISERROR(FIND(MID(B11,FIND(",",B11,1)+2,FIND(",",B11,FIND(",",B11,1)+1)-FIND(",",B11,1)-3),B16,1)),""," #"&IF(MID(B11,FIND(",",B11,FIND(",",B11,1)+1)-1,1)>RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,1)+2,FIND(",",B11,FIND(",",B11,1)+1)-FIND(",",B11,1)-5),B16,1),FIND(",",B11,FIND(",",B11,1)+1)-FIND(",",B11,1)-2),1),RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,1)+2,FIND(",",B11,FIND(",",B11,1)+1)-FIND(",",B11,1)-5),B16,1),FIND(",",B11,FIND(",",B11,1)+1)-FIND(",",B11,1)-2),1),MID(B11,FIND(",",B11,FIND(",",B11,1)+1)-1,1)))),", ",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-FIND(",",B11,FIND(",",B11,1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-FIND(",",B11,FIND(",",B11,1)+1)-2),1)),2,5)),B16,1)),"",MID(B11,FIND(",",B11,FIND(",",B11,1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-FIND(",",B11,FIND(",",B11,1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-FIND(",",B11,FIND(",",B11,1)+1)-2),1)),2,5))),IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-FIND(",",B11,FIND(",",B11,1)+1)-2),1)),"",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-FIND(",",B11,FIND(",",B11,1)+1)-3),B16,1)),""," #"&IF(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-1,1)>RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-FIND(",",B11,FIND(",",B11,1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-FIND(",",B11,FIND(",",B11,1)+1)-2),1),RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-FIND(",",B11,FIND(",",B11,1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-FIND(",",B11,FIND(",",B11,1)+1)-2),1),MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-1,1)))),", ",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-2),1)),2,5)),B16,1)),"",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-2),1)),2,5))),IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-2),1)),"",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-3),B16,1)),""," #"&IF(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-1,1)>RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-2),1),RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)-2),1),MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-1,1)))),", ",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-2),1)),2,5)),B16,1)),"",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-2),1)),2,5))),IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-2),1)),"",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-3),B16,1)),""," #"&IF(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-1,1)>RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-2),1),RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)-2),1),MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-1,1)))),", ",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-2),1)),2,5)),B16,1)),"",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-2),1)),2,5))),IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-2),1)),"",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-3),B16,1)),""," #"&IF(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-1,1)>RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-2),1),RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)-2),1),MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-1,1)))),", ",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-2),1)),2,5)),B16,1)),"",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-2),1)),2,5))),IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-2),1)),"",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-3),B16,1)),""," #"&IF(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-1,1)>RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-2),1),RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)-2),1),MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-1,1)))),", ",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-2),1)),2,5)),B16,1)),"",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-2),1)),2,5))),IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-2),1)),"",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-3),B16,1)),""," #"&IF(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-1,1)>RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-2),1),RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)-2),1),MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-1,1)))),", ",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-2),1)),2,5)),B16,1)),"",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-2),1)),2,5))),IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-2),1)),"",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-3),B16,1)),""," #"&IF(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-1,1)>RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-2),1),RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)-2),1),MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-1,1)))),", ",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-2),1)),2,5)),B16,1)),"",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-2),1)),2,5))),IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-2),1)),"",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-3),B16,1)),""," #"&IF(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-1,1)>RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-2),1),RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)-2),1),MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-1,1)))),", ",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-2),1)),2,5)),B16,1)),"",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-2),1)),2,5))),IF(ISERROR(FIND("#",MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-2),1)),"",IF(ISERROR(FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-3),B16,1)),""," #"&IF(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-1,1)>RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-2),1),RIGHT(MID(B16,FIND(MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+2,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-5),B16,1),FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-2),1),MID(B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,FIND(",",B11,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-1,1)))))

It is very specific, so if anything is changed it has to have the exact same output, even capitilization and commas are necessary for this to work. If you know of a way to bypass this error, or to achieve the same output that this formula gives using a shorter formula then please help me. Thanks in advance.

 

[Vidar]

Hi there

Impressive formula I must say.
Perhaps it would be easier to find a different solution to your problem
if you post an example of your data and what result you expect out of it.

 

[rccommando]

<a href="http://tinypic.com?ref=334n88m" target="_blank"><img src="http://i62.tinypic.com/334n88m.png" border="0" alt="Image and video hosting by TinyPic"></a>

There's probably a much easier way to do what I am trying to do, which is why I came here for help. What the above formula does is find each card from the two yellow boxes that appears in both and returns them with a comma and a space before the next card that fulfills this criteria. If there is a number sign next to a card name (designating more than one card) it also checks to see if there are multiple of that card in both boxes and if so, it returns the lower of the two numbers. What is important is that the input from both yellow boxes will always be the exact same because it is being copied from terminal and the output needs to have the same format: [card 1], [card 2] #x, [card 3] #x, etc. It also needs to be able to check whether up to 10 cards have a match in the second box. The card names can be any of over 1000, so the find function or whatever function is used can't look for specific text, but rather has to isolate a single card from the rest of the text and check to see if it is in the second box. Also, in case this helps, there will never be more than one of the first card and it must always come first. What the output of the example in the screen shot should be is: Arkadios, Dreamhaunter #2, Demi Constrictor, Xillanail, Arch Nova Alpha, Abhorrent Recluse #2

In the above formula, I was isolating individual cards using the MID function in reference to the commas that surround the cards, but I'm really hoping that there is an easier way. This is my first time using excel for anything very complicated, so I'm not familiar with many of the formulas, so if you can point me in the right direction it would be greatly appreciated. Thanks in advance.

 

[rccommando]

Bump

 

[Vidar]

I'm sorry, but I don't think I can help you with this one