|
- Function demo(rng As Range, x As Integer) As String
- Dim a, ar, i, m(1 To 2)
- a = rng.Value
- ar = Split(a, " ")
- For i = 0 To UBound(ar)
- If ar(i) <> "" Then
- If InStr(ar(i), "/") Then
- If InStr(m(1), Split(ar(i), "/")(0)) = 0 Then m(1) = m(1) & Split(ar(i), "/")(0) & ";"
- If InStr(m(2), Split(ar(i), "/")(1)) = 0 Then m(2) = m(2) & Split(ar(i), "/")(1) & "、"
- Else
- If InStr(m(1), ar(i)) = 0 Then m(1) = m(1) & ar(i) & ";"
- m(2) = "空值 "
- End If
- End If
- Next
- If x = 1 Or x = 2 Then demo = Left(m(x), Len(m(x)) - 1)
- End Function
复制代码 写了个自定义的,附件楼下
|
|