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

tata
bata
mata
pata
gata
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