Excel常用操作 从左边开始取=MID(TRIM(G2),1,5)设置字符长度,不足补零=text(C2,"000000")从右边开始取=trim(right(trim(E2),4))去括号=TRIM(J2)匹配字符=VLOOKUP(C2,aaa,4,0)来自为知笔记(Wiz)