Adding delimiters between value of two columns in excel sheet

Closed
garuna - Updated on Jul 10, 2017 at 05:20 AM
I have an problem, i made an excel macro for adding delimiters between value of two columns in excel sheet. Suppose i added delimiters between columns A as B and the result is in column C= A|B
so kindly tell me the macro to copy data from column c and then automatically paste it in a new .txt file.