Hi There,
Looking for a macro for the below situation.
Concatenation( with a hypen) of all the columns into a single last column.
Col A , Col B , Col C , Col D , Col E ,
abc , def , ghi , jkl , mno ,
After running the macro. ( First column is fixed, Second column should contain all the rest of the date concatenated.
Col A , Col B
abc , def-ghi-jkl-mno
FYI. The Data in the column can vary. ( Sometimes, data can end in Col E; Sometimes, data can end in Col Z)
Thanks.
Bookmarks