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

How to hold a UDF array formula in a variable in a vba macro?

I don't have the TEXTJOIN function in my version of excel so I created a UDF of the function in my module. What I want to do is have a macro that calls TEXTJOIN but I'm having a hard time working with the array formula with variables. My first…
gobirds12
  • 1
0
votes
1 answer

How can I use 2 cell validations on the same range?

I'm writing a database from a questionnaire, and I need certain cells to show a warning when another cell is blank and when is not certain values (like a drop-down list), how can I do that? I'm actually using =not(isblank($AU2)) for the blank part,…
Julio Andrés Leiva Valdés
  • 1
  • 1
0
votes
1 answer

Excel - Match all rows with same Code then copy and merge content of cells

In a spreadsheet with about 20k rows (shown in the image below), I need to find all the codes in Column A that are duplicates, then merge their values in Column G. These merged value need to go in the top row of the duplicated values. The values…
JHair
  • 194
  • 2
  • 11
0
votes
1 answer

ArrayFormula with TEXTJOIN - Combine data of two columns on the same row/cell

I have one Google Sheet that contains ID-values, together with corresponding Names and Attack power. In another sheet, I want to combine Names and Attack power in the same cell using the ID as a reference - separated with row breaks. Sheet1 Sheet1…
Liu Kang
  • 1,359
  • 4
  • 22
  • 45
0
votes
1 answer

Is there a good aggregate equivalent for Google Sheets with the large function?

I try to write an easy randomizer based on a database for randomly combining data. This works fine in Excel, but not in Google Sheets, because there is no aggregat I've already tried LARGE and MAX but then it's not randomizing, and with SUBTOTAL…
Benjamin Bertram
  • 3
  • 1
0
votes
3 answers

Excel Formula to Sum Delimited Values in Cells

I have two general columns of text stored in Excel, where each cell contains numbers delimited by a semicolon (delimited only if multiple numbers present). The two Excel columns always have the same number of values delimited. I'm trying to figure…
Travis Bennett
  • 131
  • 3
  • 12
0
votes
2 answers

Apply formula (processing) to Range before passing to another formula

I am trying to apply TEXTJOIN formula in one of the cells. But the problem occurred when I needed to pre-process each cell in the range. For example the data is something as below. ╔══════╦══════════════╦═════════╦═════════╦═════════╗ ║ Test ║ …
Alok
  • 42
  • 6
0
votes
2 answers

Textjoin with if(countif) function

I have some values in A1:G1 (a,a,b,c,c,d,d), they are all letters. and in H1, I try to get this result (acd). I want to join only the values that repeat twice ore more. So it should be omitted if there is a single value. I wrote this formula :…
Max
  • 932
  • 1
  • 10
  • 20
0
votes
2 answers

Excel : Columns by row value

Is there a method without using macro or script, to get this result? Bus Line L1 L2 L3 L4 Result Stops 1 X X L2,L4 2 X L4 3 X X L1,L3 I need to…
RetroMime
  • 387
  • 1
  • 8
  • 23
0
votes
1 answer

Find all occurrences and return value of the top cell in a range

Hi, I am trying the find all occurrences of a value (e.g. cat in my sample screenshot) in each month (e.g. Dec, Jan etc.) and collect all the days (e.g. 1, 4) that it occurs. I then need to do that for other values (e.g. horse, dog etc.) The…
Edmond
  • 15
  • 4
0
votes
1 answer

Using If within a Textjoin formula but ignoring blank cells

I have been trying to use a Text-join formula to pull together comments based on whether there is certain text in adjacent cells. I've used this formula which has worked fine: =TEXTJOIN("…
RM86
  • 3
  • 1
  • 3
0
votes
1 answer

Substitute textjoin formula not working for final cell

I'm trying to remove the unique values after joining cells in Excel. It's a list of phone numbers that I combine into a single cell after I separate them with a comma. I'm using this formula:…
user8529169
  • 1
0
votes
2 answers

Concatenating indeterminate number of cells ignoring blanks in Excel

Looking at the example on this page https://www.extendoffice.com/documents/excel/3269-excel-concatenate-cells-if-not-empty.html (shown below). This solution doesn't work if the last entry is blank. For example, in column A if "Order" was missing…
user7758051
  • 304
  • 2
  • 5
  • 18
0
votes
1 answer

Vlookup return multiple values

I am trying to do Vlookup to return multiple values. However, the function takes really long to load. Is there any way to make it faster ? I got the function from online:…
Rachel Chia
  • 259
  • 4
  • 11
0
votes
1 answer

Returning column names if there is match in the row, looking for multiple matches

I have one table with parts as following; --------------- | Part number | --------------- | 123456 | | 16D345 | | 16E099 | | 490586 | | 970884 | --------------- And another one like…
Bijsterz
  • 33
  • 6
1 2 3
…
22 23