How to use the CONCAT function in Excel (vs the CONCATENATE function)
How to use the CONCAT function in Excel (vs the CONCATENATE function)
Learn how to use the CONCAT function in Microsoft Excel (vs the CONCATENATE function). This tutorial demonstrates how to use Excel CONCAT to concatenate values together with an easy to follow example and step-by-step instructions. We also provide a comparison of the CONCAT function with the CONCATENATE function. The CONCATENATE function is an older Excel function that the CONCAT function is intended to replace.
CONCAT Function (and sample data):
https://www.techonthenet.com/excel/fo…
CONCATENATE Function:
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.399 -> the concat function is one of the newer
2.399 -> string functions in excel
5.6 -> it allows you to join two or more
7.359 -> strings together including ranges of
9.679 -> cells
11.12 -> the concat function is only available in
13.519 -> newer versions of excel
15.2 -> starting in excel 2019 and was intended
18.48 -> to replace the old concatenate function
22 -> one of the best features of the concat
23.76 -> function is that you can enter a range
25.519 -> of cells as a parameter
27.279 -> whereas with the old concatenate
28.8 -> function you would have to enter each
30.88 -> cell
31.359 -> as an individual parameter
34.64 -> let's take a look at how the concat
36.32 -> function works and compare it to its
38.239 -> predecessor
39.04 -> the concatenate function
42.079 -> here we have four columns of data let's
44.96 -> use the concat function to join the
46.719 -> values from these four columns into a
48.719 -> single result
51.12 -> to get started let's begin by entering
53.12 -> the concat command
55.6 -> as you can see the concat function takes
57.6 -> a series of text values as parameters
60.64 -> these text values can be strings cells
63.359 -> or ranges of cells
65.519 -> you must provide at least one text value
67.92 -> and the function can accept up to 255
70.799 -> values in total
72.72 -> and the resulting string can be to a
74.56 -> maximum of 8192 characters in length
79.28 -> since we want to concatenate the values
81.28 -> from columns a
82.479 -> to d we will enter a2 to d2
86.799 -> now let's see what our result looks like
89.52 -> you should see the value
90.84 -> abcd appear in cell f2
94.32 -> this is the concatenated values from
96.079 -> cells a2 b2
98.079 -> c2 and d2 now let's copy our formula
102 -> into cells
102.72 -> f3 to f5 notice that the result in cell
107.119 -> f3 contains the value
109 -> 1234 as a string value
112.159 -> it is important to note that the concat
114 -> function will convert all parameters to
116.159 -> strings
116.96 -> before concatenating them together into
119.04 -> the final result
120.88 -> so in this example the numeric values 1
123.439 -> 2 3
124.159 -> 4 were first converted to strings and
127.04 -> then concatenated together
128.64 -> to create the string value one two three
131.12 -> four
133.04 -> now the result in cell f4 contains
135.64 -> techonthenet.com
137.36 -> and finally the last result in cell f5
140.48 -> concatenates to values in cells a5 b5
144.239 -> c5 and d5 and returns the string value
147.52 -> alphabet
149.12 -> as you can see the concat function will
151.04 -> accept blank cells as parameters
152.959 -> such as cells c5 and d5
156.879 -> now let's use the concatenate function
159.12 -> in column h
160.319 -> to create these same results with the
162.959 -> concatenate function you cannot enter
165.04 -> ranges of cells
167.04 -> so we start with the concatenate
168.48 -> function and then enter a2
170.319 -> as the first parameter b2 as the second
173.28 -> parameter
174.8 -> c2 as the third and d2 as the final
177.92 -> parameter
179.76 -> this will give us the same result as the
181.68 -> concat function
183.04 -> which is abcd now let's copy our formula
187.28 -> into cells
188 -> h3 to h5 as you can see
191.44 -> the biggest advantage of using the
193.2 -> concat function versus the concatenate
195.36 -> function
195.92 -> is when you're concatenating ranges of
197.84 -> cells
199.599 -> also the concat function is only
201.36 -> available in excel 2019 and higher
204.239 -> whereas the concatenate function is an
206 -> older function that has been around
207.92 -> since
208.239 -> excel 2000. this completes our example
212.08 -> of how to use excel's concat function if
215.04 -> you would like to see mark and cat
216.48 -> examples
217.36 -> or would like to download the sample
218.799 -> data we used for this tutorial
220.879 -> please visit our website at
222.519 -> techonthenet.com
224.959 -> if you found our tutorial helpful please
227.04 -> leave a like on this video
228.56 -> and don't forget to subscribe to our
230.08 -> youtube channel for more great excel
232.2 -> tutorials
Source: https://www.youtube.com/watch?v=SqHgd6JkWLc