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
2
votes
1 answer

Google Sheets formula query an array based on matches from another array

I would like to filter/query Columns A:B based on 1 or more values in Column E. Essentially, I want to Return values from ColB for any values within ColA which appear in ColE. I wish I could use this: =query({$B$1:$C$101},"select Col2 where Col1='"…
Neill
  • 452
  • 2
  • 6
  • 19
2
votes
2 answers

Change cell background color based on text in another column

What would the syntax be to conditionally format - if any cell in Column A contains a value that matches any value in Column B then display a blue background? Looks like this would be done using Conditional Formatting under Format, where this custom…
Jason
  • 79
  • 6
2
votes
1 answer

TEXTJOIN for xl2010/xl2013 with criteria

I have 2 worksheets. The 1st worksheet has about 100 rows but we are only interested column Y. The cells in column Y has a mixture of blank cells (""), text and numbers, and cells that displays #N/A. Similar to the picture but with a bigger…
K.Honda
  • 3,106
  • 5
  • 26
  • 37
2
votes
1 answer

TEXTJOIN array formula (sometimes) omit last reference array on Calculate

I have a problem with TEXTJOIN formula and couldn't understand why it behaves wierdly. Any help is much appreciated. I am trying to join number and text based on condition whether the number is positive or negative, grouping them together. This is…
Rosetta
  • 2,665
  • 1
  • 13
  • 29
2
votes
2 answers

How To Find The Highest Value And Return The Two First Adjacent Cell Value In Excel?

I would like to have the two first value but I have two exact same highest value like my highest value is 20 and two-person have 20 so Excel return me the first person but not the second and I would like to have the second with. My formula is that…
Helloworld
  • 23
  • 3
2
votes
6 answers

Excel VBA - String Conactenation with delimiter and single quotes

I have a column of cells. They need to be concatenated into a single string with multiple delimiters in between. I need something like the result in column 2 from the values in column 1 Column 1 | column 2 a1 | 'a1' a2 | …
Shrilakshmi Bartur
  • 21
  • 3
2
votes
1 answer

Excel 2016: Find Numbers That Are Missing From 5000 to 6000 in one column

I have a column (A) with numbers in order from 5000 to 6000. Now, some numbers are missing. For example number 5004 is missing from the column bellow. 5000 5001 5002 5003 5005 5006 ... 6000 So, number 5004 is missing. How can I find all the…
Just Me
  • 864
  • 2
  • 18
  • 28
2
votes
1 answer

How to list multiple results returned from VLOOKUP using single formula?

I have a sample table to get the matches and need to list in a column. VLOOKUP brings only first matched column as known. So how can I list those values using only one formula? Here the table: I need to get the values which first column value…
Ali Tor
  • 2,772
  • 2
  • 27
  • 58
1
vote
2 answers

Google Sheets ARRAYFORMULA/QUERY function to group and concat rows before date

Sample Spreadsheet: https://docs.google.com/spreadsheets/d/11Kzq8cLf9ygyLfOA2rX3Hy3za_L8M_IcGDzWkacc0h0/copy Similar question (Google Sheets function to group and concat rows): Google Sheets function to group and concat rows I have two worksheets. …
Aleister Tanek Javas Mraz
  • 452
  • 2
  • 8
  • 26
1
vote
2 answers

Excel TEXTJOIN Range, Order is by numbering

I have a range that I want to use TEXTJOIN on with delimiter CHAR(10) (linebreak) The values are the header names and the order is by the numbering that is on the row. If values are empty then ignore. see image below. any help will be much…
Kobe2424
  • 147
  • 7
1
vote
1 answer

Excel - flag if a date is after a date associated with a certain criterion

Thanks in advance for your help. I have a spreadsheet of 30,000 test results - each on a unique row. Column A has the device name, B = test date, and C = test status (PA for pass or FL for fail). Each device name has multiple rows associated with it…
KRD
  • 83
  • 2
  • 11
1
vote
2 answers

Excel TEXTJOIN Multiple Categories Formula

I am looking for an Excel 365 formula to join data together in a single cell by a category and the data to be further broken out buy a subcategory on separate lines within the category cell. Please see my example data and results. I would be…
Ronan
  • 11
  • 2
1
vote
3 answers

How to change the TextJoin range in google sheet dynamically based on empty cell

I want to join the text but the number of rows differ for each record. If I use the static range data is missing for few records, in below example 22Inch is missing, Used the below formula. How to dynamically change the…
Murugesh Subramaniam
  • 313
  • 2
  • 15
1
vote
1 answer

Verify if a string entered in a cell appears in one of the cells in the column next to it, case sensitive

In my Google Sheet, I have a list of company names in column A. I need to enter a list of company names in column B, and highlight any cells in column B if the name in that cell does not appear in column A. This needs to be case sensitive. For…
GKMPinkTaffy
  • 15
  • 5
1
vote
1 answer

INDEX and Match multiple criteria

I am trying to return the points rank value when both B2 on Player lookup and C2 on Player Lookup match the DvP dataset which i highlighted in the sheet. So for example: For Lebron James I'd like to return the value from cell N89 based upon the…
TooTallDerr
  • 95
  • 5
1 2 3
…
22 23