怎么从excel提取出单元格内的内容答:(一)VBA程序代码如下:(程序运行之前请做好数据备份,以免丢失)Sub Instr_Mid()Dim i1, i2, i3, i4, i5, Arr, str1, str2, str3, str4On Error Resume NextSet mysheet1 = ThisWorkbook.Worksheets("Sheet1")mysheet1.Range("B:BBB") = "" '清空单元格Arr = Array(Chr(34), ...
EXCEL 怎么实现一行的几个单元格中取想要的字?答:如图:F1公式:=IF(COUNTA(A1:E1),INDEX({"差","一般","好","良","优"},MAX((COUNTIF(A1:E1,{"差","一般","好","良","优"})>0)*{1,2,3,4,5})),0)数组公式,按组合键(CTRL+SHIFT+回车)完成公式,下拉。