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

Referencing another cell twice in a Google Sheet formula returned error

I want to check where - in a specified range - does a value exist in a Google Sheet. If I already know the column, I would use the "Match()" function to get the row number. But let's say if I still want to get a number for the column, and use the…
Peiran Yu
  • 43
  • 6
2
votes
2 answers

Search Criteria as a range

I am trying to find a way to use a range as a search criteria. The problem is as follows: Below is a range of names in NAMES!A2:A. Names Benjamin Douglas Caitlin Enriquez Cristina Butler Emily Furse Jenny Ford Liana Fowler Lowri Donald Rachel…
emmy
  • 57
  • 8
2
votes
1 answer

Conditional formatting of a rectangle cell range defined by user input

In a Google Sheet with a cell range of 26x26 (so A1:Z26), I need to conditionally format (change the color to green) a rectangle area that is defined by user input. Example of user input (4 values required): hsize = 5 / vsize = 4 / starth = 3 /…
v0y463r
  • 23
  • 3
2
votes
2 answers

How tranpose the data of more than 1 cell to only 1 cell on google sheets?

I have the following column : A1 Miu Kei Yuk 3354 of 2018 8 April 2022 and need to separate it into 3 columns : 3354 of 2018 Miu Kei Yuk 8 April 2022 So the first and the fifth row are correct, but the row number 2, 3 and 4 needs to be in only 1…
Vitor Pinheiro
  • 35
  • 5
2
votes
1 answer

Converting Table To Columns

I have a table here where I need to populate in in columns for charting purposes, but it needs to be automated so the formula needs too be there waiting for the data. I have already found a formula for…
Rhinocerus
  • 23
  • 3
2
votes
0 answers

Excel - Return specific values if condition if met, textjoin array

I'm working on an Excel doc and really scratching my head about a problem I have. I have 2 worksheets, Main and Report. The formula I'm looking for is to search the relative candidate name in the report, search for any 'complete' courses, and return…
MidlandJoe
  • 31
  • 3
2
votes
1 answer

My QUERY+ARRAYFORMULA TEXTJOIN sheet doesn't show result as expected

I want to extract data from Column C (which contains about 1200 rows of numbers) that isn't appear inside Column B into Column E. So far i tried QUERY MATCHES and combined it with TEXTJOIN but it returned nothing. I also tried .* symbol but also…
Jirayuth Porka
  • 55
  • 6
2
votes
2 answers

Google Sheets trying to match multiple columns but the results make no sense

We have a Google Sheet where we keep "active" info vs "archive" info. We want to make sure the columns match up on both tabs so we can just do a cut-n-paste when we're moving data from Active to Archive. I'm using this formula because we're trying…
Edward Wu
  • 463
  • 4
  • 13
2
votes
1 answer

Google Sheets row to array

I need to create an array out of google sheets columns: product feature_a feature_b feature_c Array p1 1 1 1 ["feature_a","feature_b","feature_c",] p2 0 1 0 ["feature_b",] p3 1 0 0 ["feature_a",] p4 0 0 0 [] Currently my formula…
Zin Yosrim
  • 1,602
  • 1
  • 22
  • 40
2
votes
3 answers

Google Spreadsheet error Text result of TEXTJOIN is longer than the limit of 50000 characters

I am trying to combine cells and show in one cell as each cell contains product skus comma seperated. Need to combine these cells with comma seperator in seperate cell in same column. For this i am using =TEXTJOIN(",",TRUE,…
kiran kumar
  • 33
  • 1
  • 11
2
votes
1 answer

If cell contains a certain text, return a specific drop down list item (Google Sheets)

I've created a quote form, and in one cell (C6:H9) I enter the address with the city name. In another cell (C31:F31), I have a drop down list with different city names and when a city is chosen from the drop down list, it displays a certain…
ADOGG4155
  • 35
  • 5
2
votes
1 answer

Google Sheets: How to combine multiple rows in their own cells according to an ID?

I tried searching for this question very hard, and only managed to find one solution that sort of works. Here's the reference: how to merge rows together if duplicate id (google spreadsheet) His question is exactly the same as mine, and the solution…
0x00n0b0dy
  • 25
  • 1
  • 7
2
votes
1 answer

Is it possible to reference information that's currently only within a google sheet query?

I have a query (=QUERY(A9:N,"Select C,D,E,F,G,H,I where B contains """&L3&"""")) Which returns a header row and a row where the answers are either true or false - depending on the the tickboxes in the query array. I am trying to find whichever…
The_Lucky42
  • 23
  • 4
2
votes
2 answers

How to duplicate strings and attach the numeric suffix using formulas on Google Spreadsheet?

I have strings with each line in one cell. The number after # means the number of items. Is it possible on Google Spreadsheet to write a formula that allows you to process like B cell if you input strings in A cell like the attached image? I tried…
J. SungHoon
  • 201
  • 1
  • 5
2
votes
3 answers

Formatting IMPORTXML Xpath query into readable data for Google Sheets

I am importing XML data to a google sheet which has the following structure: edit: URL: https://sonicstate.com/news/tools/revive_stats/client_camp_3785.xml 15802 Some name …
Nowski
  • 173
  • 1
  • 14
1
2
3
…
22 23