Question

excel怎样以单元格中字符为条件,在单元格文字数字前加上同样的字符

excel怎样以B列单元格中某字符为条件,在A列单元格文字或数字前加上同样的字符

Answer 1

见截图

C2输入

=IF(ISNUMBER(FIND("凉",B2)),"171-",IF(ISNUMBER(FIND("单",B2)),"173-",""))&A2

公式下拉

Answer 2

=IF(ISNUMBER(FIND("凉",T1,1)),"171-"&S1,IF(ISNUMBER(FIND("单",T1,1)),"173-"&S1,S1))
单元格地址根据你的实际地址改下。

Answer 3

C2= =IF(OR(MID(B2,5,1)="凉",MID(B2,6,1)="凉",MID(B2,7,1)="凉",MID(B2,8,1)="凉",MID(B2,9,1)="凉",MID(B2,10,1)="凉",MID(B2,11,1)="凉",MID(B2,12,1)="凉",MID(B2,13,1)="凉",MID(B2,14,1)="凉"),"171-"&A1,IF(OR(MID(B2,5,1)="单",MID(B2,6,1)="单",MID(B2,7,1)="单",MID(B2,8,1)="单",MID(B2,9,1)="单",MID(B2,10,1)="单",MID(B2,11,1)="单",MID(B2,12,1)="单",MID(B2,13,1)="单",MID(B2,14,1)="单"),"173-"&A1,""))