excel中如何将四个“|”替换成ABCD答:假设答案在A1单元格,形式为:|123|234|345|3456,则公式为:=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"|","A、",1),"|"," B、",1),"|"," C、",1),"|"," D、")如形式为:123|234|345|3456,则公式为:="A、"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"|"," B、",1...
Excel题库答案分离?答:For i = 1 To 100 If Cells(i, 3) = "" Then Exit For m = m + 1 Cells(m, 4) = Left(Cells(i, 3), InStr(Cells(i, 3), "A") - 1)m = m + 1 Cells(m, 4) = Mid(Cells(i, 3), InStr(Cells(i, 3), "A"), InStr(Cells(i, 3), "B") - InStr(Cells(i...