通过excel自定义函数将汉字转换为相应的数字

tch(Test1,Result1,_    Test2,Result2,_    Test3,Result3,_    Test4,Result4,_    Test5,Result5,_    Test6,Result6,_    Test7,Result7,_    Test8,Result8,_    Test9,Result9,_    Test10,Result10,_    Test11,Result11,_    Test12,Result12,_    Test13,Result13,_    Test14,Result14)    EndFunction3.使用字符串查找函数COUNTIF(I2474,"*包半年*")较完整的实用函数资费汉字转换=Switch2(COUNTIF(D2,"*包半年*"),6,COUNTIF(D2,"*包年*"),12,COUNTIF(D2,"*包一年*"),12,COUNTIF(D2,"*包一年半*"),18,COUNTIF(D2,"*包两年*"),24,COUNTIF(D2,"*包三年*"),36,COUNTIF(D2,"*包月*"),1,COUNTIF(D2,"*包季*"),3,COUNTIF(D2,"*包十个月*"),10)优惠汉字转换=Switch2(COUNTIF(D2,"*送半年*"),6,COUNTIF(D2,"*送一年*"),12,COUNTIF(D2,"*送两年*"),24,COUNTIF(D2,"*送一个月*"),3,COUNTIF(D2,"*送三个月*"),3,COUNTIF(D2,"*送七个月*"),7,COUNTIF(D2,"*送十个月*"),10,COUNTIF(D2,"*送十五个月*"),15,COUNTIF(D2,"*包十八个月*"),10)也可以使用窗口操作,更加清析明确4。处理结果如下图