苏干湖 发表于 2021-11-19 11:53:00

请教各位大神出手

如何将以下公式写成自定义函数=MID(A1,MAX(IFERROR(FIND({"安尤","安障","一农场","安昌","三仙咀","安宏","唐家铺","三岔河","安化","安文","官当","官垱","安生","大杨树","安全","董家垱","理兴垱","安造","安福","安凝","焦圻","安金","安丰","出口洲","安裕","大鲸港","大京港","安康","下渔口","陈家咀","陈家嘴","安德","芦林铺","原种场","黄山头","城关","农科所","深柳","珊珀湖"},A1),)),3)

培养老赖的沃土 发表于 2022-2-14 00:43:12

这么数据的话做个对照表好一些吧！

人间词话 发表于 2022-2-18 05:55:30

大神，就想用自定义函数解决，望赐教！
页: [1]
查看完整版本: 请教各位大神出手