WEBVTT 00:00:00.000 --> 00:00:12.000 Hello everyone, in this video we will learn how to combine text automatically from two different or more cells using the concatenate function and symbol done. 00:00:12.000 --> 00:00:17.000 Want to know how? Watch this video carefully. 00:00:17.000 --> 00:00:32.000 First, we will learn about the concatenate function to combine text from several cells into one. 00:00:32.000 --> 00:00:36.000 So you don't get confused, let's go straight to the example of the following data. 00:00:36.000 --> 00:00:48.000 For example, in the following data, we are asked to create a store code such as GUD000 from the combination of the warehouse code and the registration number. 00:00:48.000 --> 00:00:53.000 If it is made manually one by one, it will take a lot of time. 00:00:53.000 --> 00:00:57.000 So to shorten the time, we use the concatenate formula. 00:00:57.000 --> 00:01:05.000 The way to write the formula is in the inventory cell code, which is the same as concatenate. 00:01:05.000 --> 00:01:14.000 Open the folder, select text1, which is the warehouse code, then comma or semicolon, but here I use a semicolon. 00:01:14.000 --> 00:01:19.000 Then select text2, which is the registration number, close the folder and press enter. 00:01:19.000 --> 00:01:23.000 Copy the formula file below by double-clicking like this. 00:01:28.000 --> 00:01:35.000 There is another way you can use to create an inventory code, which is with the symbol done. 00:01:35.000 --> 00:01:46.000 Write the formula formula, which is the same as, then select the warehouse code cell, add the symbol done, select the registration number, and press enter. 00:01:46.000 --> 00:01:49.000 The result will be the same as using the previous formula. 00:01:49.000 --> 00:01:53.000 Copy the formula file below by double-clicking like this. 00:01:58.000 --> 00:02:09.000 Then we will work on an example of a case in this second data, where we make a complete name from the combination of these three columns, namely the front name, the middle name, and the back name. 00:02:09.000 --> 00:02:19.000 If we make the complete name with the concatenate formula, then the names will all be combined and there will be no spaces as the separator of the names. 00:02:19.000 --> 00:02:24.000 Therefore, we need to add a space character in the writing of the formula. 00:02:25.000 --> 00:02:31.000 Then how to add a space character in the writing of the formula? 00:02:31.000 --> 00:02:35.000 How? In the complete name cell, write the formula, which is the same as, 00:02:35.000 --> 00:02:57.000 concatenate, open brackets, select the first text, which is the front name cell, then comma or dot comma, write two quotes, two quotes, dot comma, select text 2, dot comma, write two quotes, two quotes, dot comma, select text 3, close brackets and press enter. 00:02:58.000 --> 00:03:00.000 The result will look like this. 00:03:00.000 --> 00:03:12.000 If we dig deeper, to read the formula, we want to combine the first cell with a space, followed by the second cell, add another space, and add the last cell. 00:03:12.000 --> 00:03:13.000 Like this. 00:03:14.000 --> 00:03:18.000 Then we just copy the formula file below like this. 00:03:19.000 --> 00:03:23.000 Or you can use another way to combine a complete name with a symbol. 00:03:23.000 --> 00:03:43.000 How? In the complete name cell, write the formula, which is the same as, front name cell, symbol and two quotes, two quotes, symbol and middle name cell, symbol and two quotes, two quotes, symbol and back name cell, and press enter. 00:03:43.000 --> 00:03:46.000 The result will be like this, similar to the previous way. 00:03:47.000 --> 00:03:49.000 Copy the formula file below like this. 00:03:49.000 --> 00:03:59.000 This is the explanation of our video this time about the function concatenate, symbol and its application in the case study example. 00:03:59.000 --> 00:04:02.000 Don't let there is a formula or function that is wrongly written. 00:04:02.000 --> 00:04:06.000 That's all for this video, see you in the next video.