excel如何用函数从表格中把车牌提取出来?

发布网友发布时间：2022-05-07 14:18

共3个回答

热心网友时间：2022-06-09 11:54

试写了两个公式：（A2的车号没有提出来）
第一个：
=MID(A2,MIN(IFERROR(FIND(CHAR(64+ROW($1:$26)),A2),200))-1,7)
第二个：
=MID(A2,MIN(IFERROR(FIND({"京","津","沪","渝","吉","辽","晋","冀","青","鲁","豫","苏","皖","浙","闽","赣","湘","鄂","粤","琼","甘","陕","黔","滇","川","黑","蒙","新","藏","宁","桂","港","澳"},A2),"")),7)
公式下拉。

热心网友时间：2022-06-09 11:54

第一行和第二行把数字输入进去，全部选中后试一下Ctrl+E,(版本为excel2010以上

热心网友时间：2022-06-09 11:55

用代码的正则提取字符+数字组合5~7位，然后判断提取的前一位。

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com