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 and symbol function.

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 formula is in the inventory cell code, which is the same as the 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 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 folder 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 a symbol.

00:01:35.000 --> 00:01:46.000
Write the formula formula, which is the same as, then select the warehouse code cell, add a symbol, 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 folder 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 all the names will 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:32.000 --> 00:02:35.000
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:57.000 --> 00:03:00.000
The result will look like this.

00:03:00.000 --> 00:03:13.000
If we go 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, like this.

00:03:13.000 --> 00:03:18.000
Then we just copy the formula folder below like this.

00:03:18.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
The way is, in the complete name column, 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:46.000 --> 00:03:49.000
Copy the formula folder below like this.

00:03:49.000 --> 00:03:59.000
This is our video discussion 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 wrongly written function.

00:04:02.000 --> 00:04:06.000
That's all for this video, see you in the next video.