Stack Overflow
Stack Overflow

Questions tagged [textjoin]

Use the TEXTJOIN tag for questions that specify it in the question or could benefit from its use in a proposed solution.

Similar to the CONCAT or CONCATENATE worksheet functions, TEXTJOIN allows several cell values and/or string constants to be 'strung together'. TEXTJOIN has an additional parameter for a single delimiter to be used between all concatenations and a boolean option to discard potentially blank cells within a range of text values.

The TEXTJOIN was introduced with Excel 2016 in the following versions:

  • Excel for Android phones
  • Excel Mobile
  • Excel 2016 with Office 365
  • Excel 2016 for Mac
  • Excel Online
  • Excel for iPad
  • Excel for iPhone
  • Excel for Android tablet

It is currently not available within the standard desktop version.

Official support.office.com documentation page at TEXTJOIN function.

337 questions
0
votes
1 answer

TEXTJOIN of INDEX MATCH matching table headers if values aren't blank

On cell E2 I'm trying to get a TEXTJOIN with delimiter ", " (comma and a space) of INDEX MATCH to the prices you see on the right. For example the price of an apple is $$$ and also A2 is not blank so the formula will match the header of A2 (and not…
Kobe2424
  • 147
  • 7
0
votes
0 answers

Is there a way to use TEXTJOIN in Excel with arrays (columns) as input to obtain an array of concatenated rows as a result?

For simplicity, let us consider a number columns that are filled with values generated by the SEQUENCE formula with a variable number of rows (common for all columns). What I would like to obtain is another column array (with the same variable…
ZZR
  • 49
  • 4
0
votes
1 answer

Auto serial number and text in Google Sheets: "Number - Text" by dragging

For my data project, column A is Name of "number-text". Google Sheets can automatically create "text-number" by dragging. ABC - 01 ABC - 02 ABC - 03 But it doesn’t work when I use: "number - text" . Example: 01 - ABC 02 - ABC 03 - ABC How can I…
user10426840
0
votes
0 answers

Concatenating Data with Multiple Criteria Alternative to the Transpose Function

I'm attempting to return a string of values that match multiple sets of criteria. All of the criteria except for the one that looks to see if the value matches a key seem to be working. I believe it has something to do with combining a array formula…
jjcexcel
  • 1
  • 2
0
votes
1 answer

Array Formula to Combine Text with Unique Condition

I have a list of customers and the products they bought. I want to combine every product that each customer bought into respectively a single cell next to customers' name. Is there any way with array formula that can do this? The formula is expected…
Randy Adikara
  • 357
  • 3
  • 10
0
votes
3 answers

TEXTJOIN no duplicates no blanks, table, seperate columns

I have this table: on Cell A4 i want the value "Orange". I want to take only the summary of the three Fruit columns marked in orange: table format (so instead of cells B2,E2,H2 I need [@Fruit 1], [@Fruit 2], [@Fruit 3]) only the fruit columns…
Kobe2424
  • 147
  • 7
0
votes
0 answers

VBA or Excel Formula to loop up multiple values with multiple criteria

Need help with I've tried TEXTJOIN, INDEX/MATCH, CONCATENATE and don't seem to come to make it work. This is what I'm trying to do =TEXTJOIN(",",TRUE,IF(AND(TASKPRED!$B:$B=$A26,TASKPRED!$J:$J="Y",TASKPRED!$A:$A<>$C26),TASKPRED!$A:$A,"")) I have 2…
M Muaz
  • 89
  • 5
0
votes
1 answer

Excel TEXTJOIN of INDEX MATCH unique values

I have a table with 3 columns of data A,B,C. On column D I'm trying to use TEXTJOIN that ignore blanks (Columns B and C may be blanks) + unique values meaning no value from the 3 results that were joined is the same.
Kobe2424
  • 147
  • 7
0
votes
0 answers

Remove duplicate with textjoin and including criteria

I have a situation that has been killing me. So here's the dataset I want to do the text join to give me all countries with sale more than 0. I got the formula below {=TEXTJOIN(", ",,IF(B2:B6>0,IF(MATCH(A2:A6,A2:A6,0)=ROW(A2:A6)-…
Long N
  • 21
  • 5
0
votes
1 answer

How to Combine text in excel column using Textjoin

Sorry My english So bad. I want to combine data in 2 row. =TEXTJOIN("",true,G4:G12,"") Image
Dite Morin
  • 11
  • 3
0
votes
1 answer

Google Sheets: Return staff names in a comma delineated list; filtered by seasonal location and ranked by seniority

I have an extensive Google Sheet database of staff; First Name (ColA), date of availability (ColB, their name appears once {ColA} for each date {ColB} they are available), seasonal location (E-H), trip name knowledge base by area (I-O) and seniority…
Ken Parker
  • 11
  • 3
0
votes
3 answers

Equally divide a list of names in Google Sheets

We are using Google Sheets to track a list of about 60 people. We add and remove some each week. I am using functions like this to join them into a groups, =TEXTJOIN(", ", TRUE,$A$2:$A$15) I would like to replace the $A$2:$A$15 part with something…
John F. Miller
  • 26,961
  • 10
  • 71
  • 121
0
votes
3 answers

How to filter cell for string reoccurrences/duplicates?

My sheet has a cell with content: Tomato, Potato, Beef, Tomato, Salmon, Beef I want to remove all reoccurring string elements of this cell so that the new cell shows this: Tomato, Potato, Beef, Salmon I've tried to achieve this with the UNIQUE and…
Artur Müller Romanov
  • 4,417
  • 10
  • 73
  • 132
0
votes
0 answers

How to eliminate duplicates in textjoin from arrayformula

I have a borrowed piece of code that works on Google Sheets except for duplicates. The flat-file database is an index of technical articles in forty years of a monthly technical journal. On a separate sheet there is a list of "tags" which represent…
Jason Kanter
  • 1
  • 1
0
votes
3 answers

Intersection and Union of 2 cells which are strings in the excel using VBA

I have 2 cells with the contents "1 2 3" and "2 3 4", How do i find the intersection(2 3) and union(1 2 3 4) of these 2 cells and dump it in another cell. "1 2 3" and "2 3 4" are dumped by using the below guide. you can refer this question VLOOKUP…
sandeep
  • 123
  • 7
1 2 3
…
22 23