This is above formula used for the first BUS=BUSINESS, RES=RESIDENTIAL
=UPPER(MID(B2,1,FIND("=",B2)))&PROPER(MID(B2,(FIND("=",B2)+1),(FIND(",",B2)-FIND("=",B2))))&UPPER(MID(B2,FIND(",",B2)+1,FIND("=",B2,(FIND("=",B2)))))&PROPER(MID(B2,FIND("=",B2,(FIND("=",B2))),LEN(B2)+1-FIND("=",B2,FIND("=",B2))))