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

textjoin a prefiltered table in excel

Lets say that we have a table in excel. And someone applies a filter using ui (from the arrow in one column) to the whole table. So from this filtered table i want to textjoin a column (the filtered rows). Lets say we have table1 and i want to text…
kyrpav
  • 756
  • 1
  • 13
  • 43
0
votes
0 answers

Looping TEXTJOIN using vba in excel for multiple outputs

I am venturing into excel VBA the first time and wanted to run a series of codes to textjoin several columns. How do I set it to loop for selected row +1 What I would like to achieve is essentially for each row, column Q output = textjoin columns R…
jade.elves
  • 15
  • 3
0
votes
1 answer

Parenthesis in data "breaking" QUERY/TEXTJOIN formula

This formula is omitting results that contain parenthesis. I've tried SUBSTITUTE'ing the parenthesis with CHAR(40) & CHAR(41) to no avail. I've tried changing my QUERY from MATCHES to = and also CONTAINS and none of those seem to work either. Is…
TC76
  • 860
  • 1
  • 8
  • 17
0
votes
2 answers

Delimiting a column using "OR" in Google Sheets

I am using google sheets and would like to combine the text in cells of a column to a single cell separated by "OR" (with spaces on either side of the OR" For example **Column A** John Bob Jim Donald would be combined in a single cell as "John OR…
jon Myers
  • 9
  • 3
0
votes
2 answers

Pulling a range based on one criteria

I have a formula that allows me to join multiple rows together and remove duplicates: =TEXTJOIN(" ", 1, UNIQUE(TRANSPOSE(FILTER(Sheet1!A:D, NOT(REGEXMATCH(LOWER(Sheet1!A:D), "n/a")))))) The issue I'm running in to is because this references another…
Falcon4ch
  • 152
  • 1
  • 1
  • 12
0
votes
2 answers

Concatenating a range while removing duplicate values as well as specific values

I have a sheet that looks something like this: What I'd like to be able to do is concatenate this range while removing duplicate values, but also excluding certain other values. For example: I'd like to be able to see cat once (note it is in the…
Falcon4ch
  • 152
  • 1
  • 1
  • 12
0
votes
1 answer

Conditional Formatting of duplicate cells in another sheet in Google Sheets

What I am trying to do is this: Sheet1 is a table of unicode CJK characters that I have arranged in a certain way, and Sheet2 is an imported table of unsorted characters. I want to use conditional formatting to highlight the cells in Sheet2 that…
latios4
  • 1
0
votes
2 answers

Remove all HTML tags from a cell

I'm trying to remove all the HTML tags and comments within the following cell in Google Sheets:

This is a 100 count…

rip747
  • 9,375
  • 8
  • 36
  • 47
0
votes
1 answer

Google Sheet Filter excluding duplicates with condition

Having this example sheet (just sample data) Column-A Column-B Column-C 1 claudia claudia@gmail.com SOLD 2 claudia claudia@gmail.com CONTACTED 3 natalia …
sebas
  • 722
  • 1
  • 6
  • 21
0
votes
1 answer

Highlight duplicates 2 columns

Is there a way to compare 2 columns and highlight those data if column A has a partial match with data in column B?
user12046391
  • 1
0
votes
1 answer

Can Google Sheets functions name columns by their row 1 column names (price, count, etc.) rather than by column references (e.g., A, AE, etc.)

Functions in Google Sheets get hard to understand because they reference column numbers rather than column names =IF(ISBLANK(K63),"", TEXTJOIN("_",TRUE,"VO",$H63,TEXTJOIN("",TRUE,$G63,$E63),K63)) Is there a way to call columns by their row 1 name…
Joe
  • 3,217
  • 3
  • 21
  • 37
0
votes
1 answer

Using TEXTJOIN to concatenate, then IF, INDEX, MATCH to fetch data - only works when the number of 'textjoined' cells is small

I have data spread out on rows (SKU#s) that relate to a part# on the same row. I have TEXTJOINED the SKU# cells into one cell on each row. Then, on another sheet I have a formula that uses IF, INDEX and MATCH to look at a SKU# next to it, then…
Norm Robichaud
  • 7
  • 3
0
votes
1 answer

How to concatenate multiple cells (only if cell is not blank) with delimiter?

I am trying to concatenate 6 cells with a delimiter of ", " in between each cell, but while ignoring blank cells. I used this question to help me: How to Concatenate multiple columns if not empty. Problem: I ran into an issue where the delimiter…
jeidubyu
  • 3
  • 1
  • 5
0
votes
2 answers

Using SEARCH function to count occurrence of multiple values

So I've Two lists in Google sheets. one is a (relatively short) list of names, let's say a rooster of employees. The second list is (rather a long) list of shifts, which notes the employees who were present. for example: List A - (rooster): …
Doron Assis
  • 23
  • 4
0
votes
1 answer

Locate two values "empty" and "incomplete", add the values that is one column before

I am creating a spreadsheet for homework completion. I want to search "empty space" and "incomplete" and add everything into one cell. everything is in one row. I didn't do anything. I don't know how to start. I) would prefer a formula rather than a…
Kirill Soifer
  • 1
1 2 3
…
22 23