Excel: Combine data from a column to a single cell

Hi team, I want to combine data from all the cells from a column in a single cell. All the data data should be separated by as separator (of my interest like pipe, slash, comma, dot, spaces or a value ). Input -->> Selected column data

macro code generate an inputbox
inputbox ,
Output-->> cell in second next row after last row tata, bata, mata, pata, gata I hope my query is clear. Please help. Thank you

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of March 27, 2018.

For more resources for Microsoft Excel