excel函数经验收藏
1. switch语句
作用:对某一列或某一个单元格的数据进行变换处理
例如:将一列城市编码转换成中文
SWITCH(M2,"330100","杭州","330200","宁波","330300","温州","330400","嘉兴","330500","湖州","330600","绍兴","330700","金华","330800","衢州","330900","舟山","331000",...
原创
2019-02-22 13:41:38 ·
134 阅读 ·
0 评论