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

CONCATENATE Multiple cell in one

I want to merge A to Z cell in one with line break, Please tell me it's short form every two sell merge with line break A -…
Muhammad Adeeb Rana
  • 27
  • 6
0
votes
1 answer

Equivalent of Oracle LISTTAGG in Excel

I am looking to concatenate the values in MS Excel based on the keys in Col1 as shown below. This could be something equivalent of a listagg in Oracle. Kindly help as I am facing difficulty in using TEXTJOIN formula. Can someone please simplify and…
Ra-V
  • 69
  • 2
  • 10
0
votes
1 answer

Filter on Google Sheets keeping the first occurence of duplicate values in specific column

In this reading example sheet: ID Date Page Interval 1# Day Day 1 1 Day 1 - Pg. 1 2# Day Day 2 2 Day 2 - Pg. 2 3# Day Day 3 3 Day 3 - Pg. 3 of 2 4# Day Day 4 3 Day 4 - Pg. 3 of 2 5# Day Day 5 3 Day 5 - Pg. 3 of 2 6# Day Day 6 3 Day…
Bruno Silva
  • 1
  • 1
0
votes
2 answers

Search for word in a phrase and return match

I need to build a formula that: If in column X, has the values ​​of column B (regardless of position), returns the values ​​of A Column A Amoxicilina Azitromicina Cetoconazol Column B Amoxicilina Esomeprazol + Claritromicina…
Melo
  • 49
  • 6
0
votes
1 answer

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "s "" at line 1, column 2168

My exact formula below used to work previously and without changing anything except adding more data to my master table whereby 'Premium Advertisers' is populated, I get the following error: "Unable to parse query string for Function QUERY parameter…
TheReibahs
  • 23
  • 2
0
votes
1 answer

Google Sheets Select text from cell and export header names from corresponding column

I have a list of student names in a column and assessments names as a header. Along side each student I have a dropdown with either: NS S MIS I am basically trying to extract text/data when the dropdown text 'NS' and/or 'MIS' is selected. Then…
Doolz77
  • 3
  • 1
0
votes
1 answer

How do I Text join multiple cells in an array formula in google sheets

I'm having trouble with the last part of a formula on Google Sheets. In one column (B) I have cells occupied with different themes. These could be singular or have multiple themes in the cell separated by a comma. I'm matching these themes to theme…
user18110110
  • 3
  • 1
0
votes
1 answer

how to concatenate multi column cell data with quotations and commas

I had 50 columns of data from "G" to "BD" with record data organized in rows. Some cells had data, some did not. I wanted to find a way to concatenate any of the data from the columns in each row within quotation marks, and separated (delimited) by…
Debs
  • 1
  • 3
0
votes
0 answers

Search excel range for a specific column matching todays date

My Excel formula searches for a range of cells and cell that matches the date is outputted in a separate cell. That cell contains the function below. What I would like to do is instead of displaying every individual cell I would like to just display…
Max Madill
  • 39
  • 6
0
votes
1 answer

Is it possible to join a range of cells into one cell and remove 0 values?

I want to copy a range of cells into one cell with line break. My range is A1:A59. Using the following formula I managed to copy the range in the desired cell. My problem is that in this range there are some cells that have 0 and I want to leave…
ORCos
  • 89
  • 1
  • 10
0
votes
2 answers

Excel random value from a string containing substrings

I have this table that is defined as "Table1". I also have a string which contains substrings inside it with delimiter ", " (comma + space) I would like to get a formula to get one of those substrings randomly. Excel version: Excel 365 Thanks in…
Kobe2424
  • 147
  • 7
0
votes
3 answers

Conditional Formatting: multiple conditions with indirect references

I want to have text on a cell of one sheet highlighted if and only if there is a same string on another sheet AND the checkbox next to it is marked true: Sheet 1 (the current sheet that I'm doing conditional formatting on) contains "UNIQUETEXT751"…
Brandon Park
  • 77
  • 6
0
votes
0 answers

TEXTJOIN of INDEX MATCH unique values if value on another table is contained in a cell in the same row

On Column B I'm trying to get a TEXTJOIN with delimiter "," of INDEX MATCH to the price range you see on Table B. Because cell A5 contains "Apple" then "$$$" is one of the values I need, also A6 contains "Banana" then "$$" is the second value i…
Kobe2424
  • 147
  • 7
0
votes
1 answer

Google Sheets: Textjoin from another sheet not working

Working with the Base and Data tabs from this sheet: https://docs.google.com/spreadsheets/d/1OsSWQ_48VrcTU3pXGeJ_1syluKPVeVRune39UA9I3x4/edit?usp=sharing Expected result is textjoin of all colors matching SKU separated by comma in column C on Base…
Fledgling Sysadmin
  • 23
  • 1
  • 3
0
votes
1 answer

Combining rows and columns of text using Sheets Queries

I'm trying to get to an array function that will select multiple rows and columns of data and present the data cleanly in a single cell. The data in the orange headed block has multiple rows (speakers) for each ID (sessions). The data in the blue…
Chris Rosendin
  • 305
  • 2
  • 14
1 2 3
…
22 23