Excel: Can this UDF changed to Rows instead of Colomns

Hi guys, To break-down addresses this is the UDF I have been using, Can someone be kind enough to change its feature to break it down to rows instead of breaking it down to Colomns? Thanks a lot,

Function SplitValues(a As String, b As String)
  SplitValues = Split(b & String(Application.Caller.Count, a), a)
End Function

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of April 29, 2017.

For more resources for Microsoft Excel