=LOOKUP(TEXT(A1,"@"),{"0","1","2","3","4","5","6","7","8","9"},{"59","69","78","78","96","05","14","23","23","14"})
在B1中写入公式：=VLOOKUP(A1,{0,59;1,69;2,78;3,78;4,96;5,"05";6,14;7,23;8,23;9,14},2,0)
没规律可循的嘛
