Hello and welcome to our new video in this video we are
going to learn about concatenate formula now what is
concatenate formula?
You have two names one is name and other one is surname if
you want to join them then how will you join them?
So we are going to learn how to join them using concatenate
formula
We have already seen that we can use AND formula and using
that we have joined the names
So this is also similar kind of formula
We will learn how to use AND formula and how to use
concatenate formula
So let's open excel
I have some names written here
All the names are written here and here is surname
So now I have to use concatenate formula
Now let me tell you one thing that these names are called
string
And if I write single then it is called character
Let's increase it
If I write single then it is called character
And if I write full name then it is called string
How many characters are there in this string? 1,2,3,4,5 I
just wanted to tell you so that you know the difference
So now let's see how to use concatenate formula
First of all you have to sign equals to
Then you have to write concatenate
It will ask you for two strings
Tags1 and Tags2
Tags1 is Rahul
Then you have to write comma
Tags2 is Rohila
I have done this
After that I have done enter
Now it is Rahul Rohila
Let's increase the size of it
Otherwise it will always look small
It is enough
But here is a problem
Before that let's drag it
You will not be able to see the space in it
Space is the biggest problem
So what I have to do
I have to go here
First I will remove it
I have to give space in front of it
Like I have given space here
After that
See the space has come
Now let's do it
Will there be space in all?
No, there will not be space in all
Because there is no space in front of all
So you have to individually
Put space in front of all
Right
Now let's put space in front of all
But how much time will be consumed in it
So this is a drawback of this formula
That here
It shows both the names
In this way
So Apart from this
What we did in the end
We did the same thing in the end
We could have done it in the end
And we had seen this before
End So here we understood this thing
The function of concatenate
How it is used
I can add the two names that I have
So we added it here
If I am here instead of concatenate
I use
How do they do it
That is simple
We know that
After that
Like this name
Select it
Enter Rahul rohila
Rahul rohila
From here
And its size
Increase it 18 Right So we have seen from the end formula
And we have seen from the function of concatenate
So I hope you have understood
How it is used
So if there is any doubt in the video
Then play this video again
I will meet you in the next video
Till then keep practicing