I used a handy little Excel macro to concantenate an entire column into one cell and add a pipe character (|) in between all the values.
So, should you ever need to accomplish this task here is the VB macro for Excel!
You can then call it from the cellFunction custom1(rng As Range, Optional delim As String = " ") Dim myAdd As String myAdd = rng.Address vishal = Join(Evaluate("transpose(" & myAdd & ")"),delim) End Function
=custom1(A1:A20,"|")
No comments:
Post a Comment