EXCEL脚本拼接字串

=CONCATENATE("<apn carrier=",CHAR(34),CHAR(34),CHAR(10),"area=",CHAR(34),$A2,",",$B2,CHAR(34),CHAR(10),"mcc=",CHAR(34),$C2,CHAR(34),CHAR(10),"mnc=",CHAR(34),$D2,CHAR(34),CHAR(10),"apn=",CHAR(34),$F2,CHAR(34),CHAR(10),"/>",CHAR(10))

Area

Country

MCC

MNC

MCC+MNC

Name

Africa

Egypt

602

01

60201

Mobinil

<apn carrier="" area="Africa,Egypt" mcc="602" mnc="01" apn="Mobinil" />

编辑出来的就是这样

=CONCATENATE("<apn carrier=",CHAR(34),C3,CHAR(34),CHAR(10),IF(C12="<blank>",CHAR(32),CONCATENATE("user=",CHAR(34),C12,CHAR(34),CHAR(10),"password=",CHAR(34),C13,CHAR(34),CHAR(10))),"mmsc=",CHAR(34),C2,CHAR(34),CHAR(10),IF(OR(C5="No",C5="no"),CHAR(32),CONCATENATE("mmsproxy=",CHAR(34),C6,CHAR(34),CHAR(10),"mmsport=",CHAR(34),C7,CHAR(34),CHAR(10))),"/>",CHAR(10))


=CONCATENATE("<apn carrier=",CHAR(34),CHAR(34),CHAR(10),"area=",CHAR(34),$A2,",",$B2,CHAR(34),CHAR(10),"mcc=",CHAR(34),$C2,CHAR(34),CHAR(10),"mnc=",CHAR(34),$D2,CHAR(34),CHAR(10),"apn=",CHAR(34),$F2,CHAR(34),CHAR(10),"/>",CHAR(10))


=CONCATENATE("<apn carrier=",CHAR(34),C3,CHAR(34),CHAR(10),IF(OR(C12="<blank>",C12="Blank",COUNTIF(C12,"*ank*")),CHAR(32),CONCATENATE("user=",CHAR(34),C12,CHAR(34),CHAR(10),"password=",CHAR(34),C13,CHAR(34),CHAR(10))),"mmsc=",CHAR(34),C2,CHAR(34),CHAR(10),IF(OR(COUNTIF(C5,"*No*"),COUNTIF(C5,"*no*")),CHAR(32),CONCATENATE("mmsproxy=",CHAR(34),C6,CHAR(34),CHAR(10),"mmsport=",CHAR(34),C7,CHAR(34),CHAR(10))),"/>",CHAR(10))




=CONCATENATE(<apn carrier=,C3,CHAR(10),IF(OR(C12="<blank>",C12="Blank",COUNTIF(C12,"*ank*")),CHAR(32),CONCATENATE(user=,C12,CHAR(10),password=,C13,CHAR(10))),mmsc=,C2,CHAR(10),IF(OR(COUNTIF(C5,"*No*"),COUNTIF(C5,"*no*")),CHAR(32),CONCATENATE(mmsproxy=,C6,CHAR(10),mmsport=,C7,CHAR(10))),/>,CHAR(10))