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