Giống như hàm Vloolup, sum, max ... ta có thể viết 1 hàm riêng trong VBA Excel
Function getVLK_My(rge As Range) As String
Dim kq As String
arrData = rge
For iNum1 = 1 To UBound(arrData , 1)
For iNum2 = 1 To UBound(arrData , 2)
'MsgBox first(iNum1, iNum2)
kq = kq & " - " & arrData (iNum1, iNum2)
Next iNum2
Next iNum1
getVLK_My = kq
End Function