I have 20 names in a column and want to combine all these names into one continuous string, in one cell. So whenever one of these cells changes, the output in the single cell should automatically change.
I dont want to concatenate them individually as there maybe times when i have more than 20 names and I'll need to manually change the formula in that case.
Any ideas?
I dont want to concatenate them individually as there maybe times when i have more than 20 names and I'll need to manually change the formula in that case.
Any ideas?