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
2 answers

Ranges within ArrayFormula in Google Sheets

Is it possible to include ranges of ranges in arrayformulas in Google Sheets? For instance, the normal formula is: =TEXTJOIN(" ",TRUE,A1:C1) This joins the cells in range A1:C1 with a space However, I want this to repeat over the entire column, so…
Neji Yang
  • 9
0
votes
0 answers

Excel formula return values vertically

I have a formula set up that is collecting all the values to a corresponding Reference cell. My formula is working great and returning all the values its finds for that particular reference in a single cell (ie 123, 1234, 4422) but I am having…
Elliott1197
  • 89
  • 1
  • 9
0
votes
1 answer

Multiple criteria match Google sheets

I have 2 tabs in google sheets that are Col1 Col2 1 A 1 B 1 C 1 D 2 X 2 Y 2 Z Col3 Col4 1 ABCD 2 XYZ I want to fill Col4 with all matching values by joining Col3 and Col1, I have…
GI.JOE
  • 69
  • 1
  • 8
0
votes
0 answers

Google Sheets Text Join to join character from columns into row

have data like this and want result like this using this formula: =ARRAYFORMULA(REGEXREPLACE(TRIM(SPLIT(TRANSPOSE(QUERY(QUERY( IF(D2:D<>"", {C2:C&"♠", D2:D&","}, ), "select max(Col2) where Col1 is not null group by Col2 pivot Col1") ,,999^99)),…
Mahardi Setyoso
  • 11
  • 1
  • 3
0
votes
1 answer

Combining cell text based on a date range

Trying to get rows on Master sheet to combine into single cells on 2nd Sheet based on which date range they fall into. Here's the example sheet. I've got some attempts and then an example of what product I'm hoping for.
harrycoin
  • 85
  • 1
  • 1
  • 4
0
votes
2 answers

How to collapse sheets query result into a single cell

I have a sheets query that almost does what I want but I need a bit of help to get to the last step. =QUERY(Sales!$A$2:$C,"SELECT B, SUM(C) WHERE A='"&B3&"' GROUP BY B ORDER BY SUM(C) DESC LIMIT 3 LABEL SUM(C) '' FORMAT SUM(C) '$##,##0'…
Chris Rosendin
  • 305
  • 2
  • 14
0
votes
0 answers

Join text from multiple rows based on common attribute in Excel

I have a table of data in Excel that has a company ID in one column and a NAICS code in another column. Only one NAICS code can be entered per row. Within the table a company ID can appear more than once with the same or a different NAICS code. In…
Danny
  • 554
  • 1
  • 6
  • 17
0
votes
2 answers

Google Sheets function to check containing string + evaluation

I would really appreciate if someone could help me with this. I have a file in Google Sheets with one column that could have information in there like this: piktogramm_ghs02.jpg,piktogramm_ghs07.jpg, piktogramm_ghs08.jpg, piktogramm_ghs09.jpg I…
Sepp
  • 1
0
votes
1 answer

How can I combine these two formulas?

Example I want to combine these two formulas but can't seem to the ' and " right? I want to output a table that has the data from the source tables whose sheet name is checked in sheet FL-elever: Formulas to join: Checked names to…
Allan Bech
  • 391
  • 1
  • 6
0
votes
1 answer

Textjoin: Using a unique ID, how do I concat multiple values?

I'm having trouble getting this to work. Basically, I have the following set of data: In the TextJoin Formula column, I want it to do a look up against the adjacent ID, scan the income code column and concat the income codes pertaining to that…
Jason
  • 47
  • 1
  • 7
0
votes
1 answer

Use a single column to index/match in two columns

I want to use a single column to do a lookup in two columns. Example below. | a | | c | a | foo | | c | a | foo | | b | | e | c | bar | | b | a | baz | | c | | b | a | baz | | d | The first table is the data I'm using to match on. The…
user12785973
  • 21
  • 2
0
votes
1 answer

Formula that lookup a row and get results like textjoin from non blank cells

Hy all I need help with a formula I want result like textjoin but without zeros in empty cell, and to combine a column name with cell data. below table is example of results. with textjoin I get for eg. Jill = 0,0,2,0,0 i want to skip zeros and…
Karlo Roginić
  • 1
  • 1
  • 1
0
votes
1 answer

TextJoin Remove Duplicates but with an If Function filter

I am using the new TextJoin function with a Match and a IF function as a filter. The statement works for the most part, but for every row that dos not meet the filter requirement it returns a "False". Is there a way to filter and not get a bunch of…
Bob
  • 127
  • 2
  • 10
0
votes
0 answers

offset gives 0 for empty cell excel

I have a followup question to this problem. Lets say I have an array with three columns and 4 lines like this: ST1 ST2 INFO 1 0 one 0 1 two 0 0 three 1 1 Function =TEXTJOIN("; "; 1; IF(SUMPRODUCT((Table1[INFO]…
MocS
  • 37
  • 7
0
votes
2 answers

conditional formatting based on values from a column

I have a matrix in my google sheet. I want to color a cell if its value is present in another array, meaning one cell of that array is identical. I am able to do it using conditional formatting and checking only one cell instead of the whole array,…
tidus95
  • 359
  • 2
  • 14
1 2 3
…
22 23