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
57
votes
5 answers

MS Excel - Concat with a delimiter

I've got a long spreadsheet with numbers. I need to get them in one string delimited by ; eg. 4364453;24332432;2342432 I know I can do: =concat(A1:A2000) but that will merge it in one string without the delimiter - I can't seem to find an option…
Wasteland
  • 4,889
  • 14
  • 45
  • 91
11
votes
2 answers

TEXTJOIN only when the condition is met?

I tried using TextJoin function with IF in it, but it somehow doesn't seem to work. I think I've written the formula correctly, but it doesn't give the solution I'm attempting to get. Objective: I want the values from A-column to get printed out…
user234568
  • 741
  • 3
  • 11
  • 21
11
votes
2 answers

Vlookup using 2 columns to reference another

I am trying to do a vlookup under a circumstance of first then last name to get an age. This will be done within Column A, then Column B. If found in Column A, Continue to Column B, If found in Column B, put age in J3 that comes from Column C else…
Brad
  • 1,450
  • 2
  • 16
  • 37
6
votes
3 answers

How to concatenate values in multiple cells based on a condition?

I have a need to search a row of cells, and for every cell that contains a specific value, return the value from the cell above. For example, consider the following +---+--------+--------+--------+--------+--------+----------+ | | A | B …
Typhoon101
  • 2,063
  • 8
  • 32
  • 49
4
votes
3 answers

Google spreadsheet left formula with ellipsis

I'm using importxml to import some data from an other website. This results in some cells to show long text. I'm using =LEFT formula to limit the number of characters in a cell but words stop very abruptly and i was wondering if i can add ellipsis…
John Grischam
  • 224
  • 1
  • 19
3
votes
1 answer

Combine specific columns into one column in Google sheets

I am trying to transpose the data in the table so that Conversion Types are all stacked in one column with corresponding values. Please see the example in this sheet:…
SanLot
  • 65
  • 3
3
votes
2 answers

Google Sheets Text Join to consolidate rows into columns

I have a "database" table in sheets where each row is a person/email associated with a company and contact role. So, a company will have multiple rows of contacts for various roles (sales, marketing, etc) and can have more than one person that does…
Chris Rosendin
  • 305
  • 2
  • 14
3
votes
2 answers

Filter with REGEXMATCH in Google sheet to filter out containing text in cells

Right now I have these data and I'm trying to filter out the data containing in cell C3, C4, etc. I have no problem filtering the regexmatch data for 1 cell as shown below but I'm unable to do regexmatch for more than 2 cells like so for example,…
Lyber
  • 147
  • 1
  • 4
  • 20
3
votes
2 answers

Merge all cells to one cell and separate with comma

I use Google Sheets, and I want to get data and create one new cell. Example: I have 300 rows and 4 columns, like: 1|3|2|4 5|7|6|8 9|11|10|12 ... 297|299|298|300 and one cell that I need in…
user10426840
3
votes
2 answers

Excel TEXTJOIN with multiple IF conditions

I'm trying to use the TEXTJOIN function to create a comma separated list of the content of each row's Column D value, but only when it's Column J value reads "Regulatory" and it's Column K value reads "No".  I can get it to do this with one…
Tom Sutherland
  • 53
  • 1
  • 2
  • 6
3
votes
1 answer

Search a single cell for multiple words AND return all words found

I have been trying all day to write a formula in Excel that can search a string for multiple keywords and then print which keywords it found in a cell. I've gotten as far as searching for a list of keywords and returning the first keyword found, but…
DirtAndPlantScientist
  • 43
  • 2
  • 5
3
votes
1 answer

Concatenate multiple results from an index match

I'm trying to concat multiple results from an index match into one cell. Here is an example data set I'm working with: My desired results: As you can see, I'm trying to find all customers where the data is 4/12/2017. I then want to combine them…
Djones
  • 109
  • 1
  • 1
  • 7
3
votes
1 answer

Concatenate column headers if value in rows below is non-blank

I have table with data in the format below. Data I want the finished table to have the blank column to be populated like the highlighted one below. Finished Table So, I need a formula or VBA that will return and concatenate the headers of…
Elissa
  • 49
  • 1
  • 5
3
votes
1 answer

Separate line breaks into columns

I have one cell with text. The text string looks like the following: Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text. I read to use Text-to-column, use as…
Carol.Kar
  • 4,581
  • 36
  • 131
  • 264
2
votes
2 answers

Combine cells that fall within one range

I have a set of data with numbers in Column A, then in column B and C there is data in multiple rows per number. I would like to combine each column of data such that there is only one row per number. For example, what I have is: Column…
user21407613
  • 21
  • 2
1
2 3
…
22 23