Nov 19 2018 08:15 AM
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?
Example:
234AB234
9430D5423K
KENO934DW
9443G74K
Needs to be: 234AB234, 9430D5423K, KENO934DW, 9443G74K
Nov 19 2018 08:36 AM
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
Nov 19 2018 08:50 AM
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.
Nov 19 2018 12:44 PM
TEXTJOIN doesn't work since you don't have it (you are not Office365 subscriber) or that's something else?
May 31 2019 01:29 PM
@Sergei Baklan I have experienced the same issue (TEXTJOIN doesn't work) while attempting to combine data from 33 rows into a single row separated by a comma. Do you know of another method that does not require extensive data entry?
May 31 2019 02:57 PM
@shayalynn , several ways without it
https://chandoo.org/wp/combine-text-values-quick-tip/
http://www.excelcampus.com/keyboard-shortcuts/concatenate-range-of-cells/
plus with PivotTable
Apr 16 2024 01:30 PM
Combine data in 3 rows of column A into one field separated by commas:
A1: ab
A2: cd
A3: ef
1. In B1 enter function: =concat(a1,", ") and copy function to all rows below. Results:
B1: ab,
B2: cd,
B3: ef,
3. Copy column B and Paste Values to column C
4. In D1, enter function =concat(C1:C3). Results: ab, cd, ef
5. Copy D1 and Paste Values to E1.