Quote Originally Posted by Rick Rothstein View Post
I'm glad I asked about that #NAME? error as those lines of code required special handling. Give this macro a try...
I highlighted in red the location where the delimiter is specified in case you want to change it in the future.


Rick,

The macro worked very nicely. My team is very impressed!!

Can we nuance it to align the concatented line directly to the right of its starting point rather than at the top of the column?

JOHN