Excel字符串连接的函数怎么写答:点A2——在编辑栏输入:= 再选第一行数据区域(如A1~A100)——编辑栏变成:=A1:A100 不要回车!——按F9——编辑栏变成={1,2,3,4,5,6...} 删除等号“=”和大括号“{}”——回车——A2单元格变成:1,2,3,4,5,6...选A2——Ctrl+H——查找内容:,替换为:& 替换(完成了)。
谁知道excel中sumif函数的vba写法???答:Public Function TJQH(R1 As Range, TJ, Optional R2)Dim ARR1, ARR2, i As Long, j As Long, S As Double, F As Boolean ARR1 = R1.Value If IsMissing(R2) Then ARR2 = R1.Value Else ARR2 = R2.Value End If S = 0 If Not (TJ Like "[= ,< , <= ,> ,>= , <...