Forum Discussion
Combine data from multiple rows into a single row separated by a comma and space
I have a lot of data I'll need to move from one column into one single cell separated by comma space. The data is letters and numbers. I've tried the TEXTJOIN feature and it's not working. Any ideas?...
you can use Concatenate function or "&" sign between adresses to add multiple text together for example if you have 234AB234 in cell A1 and 9430D5423K in cell A2:
=A1 &", " A2
formula will gibe "234AB234, 9430D5423K" as result
To add to erol sinan's formula, in cell B2, enter the formula =B1&", "&A3, then use the auto fill handle to copy it down.