<excel如何用函数从表格中把车牌提取出来?-百科大全-龙咔百科
> 百科大全 > 列表
excel如何用函数从表格中把车牌提取出来?
时间:2024-12-23 19:42:42
答案

试写了两个公式:(A2的车号没有提出来)

第一个:

=MID(A2,MIN(IFERROR(FIND(CHAR(64+ROW($1:$26)),A2),200))-1,7)

第二个:

=MID(A2,MIN(IFERROR(FIND({"京","津","沪","渝","吉","辽","晋","冀","青","鲁","豫","苏","皖","浙","闽","赣","湘","鄂","粤","琼","甘","陕","黔","滇","川","黑","蒙","新","藏","宁","桂","港","澳"},A2),"")),7)

公式下拉。

推荐
© 2024 龙咔百科