MID函数使用示例

学号120305120203120104120301120306120206120302120204120201120304120103120105120202120205120102120303120101120106姓名包宏伟陈万地杜学江符合吉祥李北大李娜娜刘康锋刘鹏举倪冬声齐飞扬苏解放孙玉敏王清华谢如康闫朝霞曾令煊张桂花班级3班2班1班3班3班2班3班2班2班3班1班1班2班2班1班3班1班1班语文91.5093.00102.0099.00101.00100.5078.0095.5093.5095.0095.0088.0086.00103.50110.0084.0097.5090.00数学89.0099.00116.0098.0094.00103.0095.0092.00107.0097.0085.0098.00107.00105.0095.00100.00106.00111.00英语94.0092.00113.00101.0099.00104.0094.0096.0096.00102.0099.00101.0089.00105.0098.0097.00108.00116.00生物92.0086.0078.0095.0090.0088.0082.0084.00100.0093.0098.0089.0088.0093.0099.0087.0098.0072.00地理91.0086.0088.0091.0087.0089.0090.0095.0093.0095.0092.0073.0092.0093.0093.0078.0099.0095.00历史86.0073.0086.0095.0095.0078.0093.0091.0092.0092.0092.0095.0088.0090.0093.0089.0099.0093.00政治86.0092.0073.0078.0093.0090.0084.0092.0093.0088.0088.0091.0089.0086.0092.0093.0096.0095.00总分629.50621.00656.00657.00659.00652.50616.00645.50674.50662.00649.00635.00639.00675.50680.00628.00703.50672.00平均分89.9388.7193.7193.8694.1493.2188.0092.2196.3694.5792.7190.7191.2996.5097.1489.71100.5096.00要求：学生学号第4位为所在班级，如学号120305则示例：C1函数为=MID(A2,4,1)&\"班\"，括号第一个数字找字符长度为1个长度，则得到“3”。0305则在3班，试用MID函数填入班级在C列

个数字为函数在A2单元格查找第4位开始的字符、所查