|
用自定义函数处理一下吧!比较灵活点,就两个参数。
第一个参数为合并范围,第二个参数为分隔符,具体用法可参见附件的G8单元格。
P.S. 使用前请先启用宏。
- Option Explicit
- Function hebing(rg As Range, ss As String)
- Application.Volatile
- Dim arr
- Dim i As Long, j As Long
- Dim sr As String
- If IsArray(rg) Then
- arr = rg.Value
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If Not IsEmpty(arr(i, j)) Then sr = sr & ss & arr(i, j)
- Next j
- Next i
- hebing = Mid(sr, Len(ss) + 1)
- Else
- hebing = rg.Value
- End If
- End Function
复制代码
|
|