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

How to take formula inputs to a UDF like conditional formatting

Imagine you want to check whether the left letter of each word in a range is "a", then join the words for which that condition is true. One way is with a helper column, returning "" if not true, the word if it begins with "a", and then a total row…
Greedo
  • 4,967
  • 2
  • 30
  • 78
0
votes
2 answers

Pick values from multiple cells and paste output in one cell

I have a dataset which looks like: A 0.998315185 B 0.232720507 C 0.010558964 D 0.004246209 E 0.002552556 I want to paste below output in one cell as: 0.998315185A+0.232720507B+0.010558964C+0.004246209D+0.002552556E So that I can copy…
ROY
  • 268
  • 2
  • 11
0
votes
2 answers

VBA - Count empty cols, search and replace

I'm learning VBA and trying to do something a bit complicated for me. Here's the deal : In my "H" column, I'm using the "CONCATENATE" formula to get a key of all the elements I want in my columns, for each line. As you can see, some elements aren't…
Jeanjean
  • 723
  • 2
  • 12
  • 22
0
votes
3 answers

Excel formula to return multiple column names

I am trying to get a formula that searches each row for a "Yes". It then should list the column name(s). Some row may only have 1 yes, some may have 3 or more. I have tried searching and editing several suggestions, but cannot get the one I need.…
Adrienne
  • 5
  • 3
-1
votes
1 answer

How to generate SQL code from Google Sheet

I have a google Sheets that looks like this : ID | City | Capital | Country ------------------------------- 5 | Paris | Yes | France 8 | Madrid| Yes | Spain I would like to find a way to generate this kind of code for each line update database…
Andrea Costanzo
  • 61
  • 6
-1
votes
1 answer

Excel Text Join: Extract Cell Values From Duplicated Column Values

I have the following scenario: I have repeated values in Column C and Column D. I have some values in column E. Problem Output required: I have the unique values of column C in the Column K and unique values of column D distributed in Row 4…
Neverland
  • 1
  • 2
-1
votes
1 answer

How do I use regex in sheets to number (in cell) everything new line that starts with Letters?

My goal is to get something like this goal. For every new line after the 1st one if it doesn't start with a ">" I want it to be numbered (starting from nr. 1 on), as for the lines that start with ">" - to just return those without numbering them.…
Debora S.
  • 115
  • 8
-1
votes
1 answer

TextJoin Matrix

Hello stackoverflow community! This is my first post on here so be gentle! I have been working on trying to automate the naming system for the creation of new products at the company I work for. We come out with new SKUs pretty often so I want to…
Orion Hunt
  • 1
  • 2
-1
votes
1 answer

Google Sheets Query needed to select values matching in other column

been trying to solve this query for a while, tried many variations and never was successfull.. I have the following data set.. I am trying to write a =QUERY() to get the output like in the image below..
Mr.Eboy
  • 45
  • 9
-1
votes
1 answer

conditional formatting to keep track of difference in two data sets

I am looking for a way to keep track of the differences in two similar data sets, using conditional formatting. Example sheet on the local sheet I would like to see the cells that have different values highlighted, on the global sheet I would like…
DiceB
  • 1
  • 1
-1
votes
1 answer

I need to find links that contain the same number and merge them all into the same cell

can someone help me speed up the process in excel. I need formula to find links that contain the same number and merge them all into the same cell. So far I've done it with the formula but it's a slow process for me when I have over 1000…
Regi
  • 3
  • 1
-1
votes
1 answer

TEXTJOIN cells that only meet the IF

I am working on Google Sheets and have not incorporated Google Script to this question. I have automated a process based on data validation but I wish to make the data look less chunky. My aim is to join the text using a delimiter ", " but ONLY IF…
Shea Murphy
  • 5
  • 3
-1
votes
3 answers

How to calculate average of percentage for each row in Google Sheets

In column D, for each student I'd like to find average of percentage of all the tests they took. For Student 1, I need to take percentage of each test by 8/10, 25/25, 35/50 and find average in D6, etc. I tried =average(($E6:$E100)/($E3:$AB3)) but…
shin
  • 31,901
  • 69
  • 184
  • 271
-1
votes
2 answers

Extracting all rows that matches a "pattern" from a range

I'm very new to this and I've googled about regex and RE2, but little help is found. Seems to be rather niche topic and the material isn't quite comprehensive. Would appreciate any help in this. Thank you! I have a list with over 30k rows of text…
W.B. Sam
  • 11
-1
votes
1 answer

TRIM & Remove Duplicate and TEXTJOIN a variable range using VBA

I would like a range most varying say A1:A20 pulled from an application with space in beginning or in end so it need to be TRIM and then Remove Duplicates, remove blank cells and they need to be TEXTJOIN(",",TRUE,A1:A20). Range is variable. So that…
Biju Jacob
  • 1
  • 2
1 2 3
…
22
23