Concatenate multiple columns into a last column

[v_a_royston]

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.

[zbor]

You can use this snb's UDF:

Please Login or Register  to view this content.

in last column. Copy as value after it's done and delete other columns.

c01 is range
c03 is separator (in your case "-")