主题：[求助]求助一个安排考场编号代码的公式

试试“代码”列刷新公式：

"D" + If(Instr("1",Split([考场相加]," ",2)) >= 0,"1",If(Instr("2",Split([考场相加]," ",2)) >= 0,"2",If(Instr("3",Split([考场相加]," ",2)) >= 0,"3",If(Instr("4",Split([考场相加]," ",2)) >= 0,"4",If(Instr("5",Split([考场相加]," ",2)) >= 0,"5",If(Instr("6",Split([考场相加]," ",2)) >= 0,"6",If(Instr("7",Split([考场相加]," ",2)) >= 0,"7",If(Instr("8",Split([考场相加]," ",2)) >= 0,"8",If(Instr("9",Split([考场相加]," ",2)) >= 0,"9"," "))))))))) + "H" + If(Instr("一",Split([考场相加]," ",1)) >= 0,"1",If(Instr("二",Split([考场相加]," ",1)) >= 0,"2",If(Instr("三",Split([考场相加]," ",1)) >= 0,"3",If(Instr("四",Split([考场相加]," ",1)) >= 0,"4",If(Instr("五",Split([考场相加]," ",1)) >= 0,"5",If(Instr("六",Split([考场相加]," ",1)) >= 0,"6",If(Instr("七",Split([考场相加]," ",1)) >= 0,"7",If(Instr("八",Split([考场相加]," ",1)) >= 0,"8",If(Instr("九",Split([考场相加]," ",1)) >= 0,"9",If(Instr("十",Split([考场相加]," ",1)) >= 0,"10"," "))))))))))