How to use the TEXTJOIN function in Excel
How to use the TEXTJOIN function in Excel
Learn how to use the TEXTJOIN function in Microsoft Excel. This tutorial demonstrates how to use Excel TEXTJOIN with our easy to follow examples and takes you step-by-step through the different options when entering your formula.
TEXTJOIN Function (and sample data):
https://www.techonthenet.com/excel/fo…
Excel Functions/Formulas:
https://www.techonthenet.com/excel/fo…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0.16 -> the text join function is a new function
2.56 -> that is available starting in excel 2019
5.839 -> as well as office 365.
9.44 -> it allows you to join two or more
11.28 -> strings together with each value
13.36 -> separated by a delimiter let's take a
16.64 -> quick look at how to use the text join
18.56 -> function in excel
20.72 -> here we have four columns of data let's
23.6 -> use the text join function
25.279 -> to join the values from these four
26.96 -> columns into a single result
28.96 -> with a comma as a delimiter between each
31.199 -> value
33.36 -> to get started let's begin by entering
35.44 -> the text join command
38.16 -> as you can see the text join function
40.16 -> takes a number of parameters
42.8 -> the first parameter we will enter is a
44.719 -> delimiter
45.92 -> this is a string that will be inserted
47.76 -> between each text value
50 -> most commonly you would use a delimiter
52.079 -> such as a comma or space character
54.96 -> in this tutorial we will use a comma the
58.079 -> second parameter determines whether
59.84 -> empty values are included in the
61.6 -> resulting string
63.44 -> true ignores empty values and false
66.96 -> includes empty values in the result so
69.84 -> let's enter true
71.04 -> so that empty values are ignored the
74.08 -> next parameters are the strings that you
75.92 -> wish to join together
77.759 -> you must enter at least one string and
79.92 -> you can enter up to 252 strings in total
83.68 -> in this example we want to join the
85.36 -> values from columns a through d
87.759 -> so we will enter a2 b2
90.88 -> c2 and d2 now let's see what our text
94.96 -> join function returns
97.28 -> you should see the value a comma b comma
100.079 -> c
100.479 -> comma d appear in cell e2
103.84 -> this is the concatenated values from
105.759 -> cells a2
107.04 -> b2 c2 and d2 with commas delimiting each
111.2 -> of these concatenated values now let's
114.399 -> copy our formula
115.439 -> into cells e3 to e5
118.56 -> notice that in cell e3 it has converted
121.119 -> our numbers to strings
122.56 -> and then concatenated the values to
124.24 -> return 1 comma 2
126 -> comma 3 comma 4 as the result
129.44 -> in cell e4 the text join function has
131.92 -> returned
132.48 -> tech comma on comma the common net
137.04 -> and in cell e5 the text join function
139.92 -> has ignored the empty cell
141.36 -> c5 and d5 and returned alpha comma bet
145.28 -> as the result this completes our example
149.36 -> of how to use excel's text join function
152.319 -> if you would like to see more examples
154.319 -> or would like to download the sample
155.76 -> data we used for this tutorial
157.68 -> please visit our website at
159.319 -> techonthenet.com
162.16 -> if you found our tutorial helpful please
164.239 -> leave a like on this video
165.76 -> and don't forget to subscribe to our
167.36 -> youtube channel for more great excel
169.44 -> tutorials
Source: https://www.youtube.com/watch?v=KNRuuKsRmc4