从左边开始取

=MID(TRIM(G2),1,5)

设置字符长度，不足补零

=text(C2,"000000")

从右边开始取

=trim(right(trim(E2),4))

去括号

=TRIM(J2)

匹配字符

=VLOOKUP(C2,aaa,4,0)