0:00
hi everyone and welcome back to Excel
0:03
with in today's video I'm going to show
0:05
you how to combine four columns in Excel
0:09
using three very easy methods the first
0:12
one is by the use of concatenate
0:15
function the end operator and the text
0:18
join so as you can see we have our first
0:20
name last name city and country so we
0:23
want to combine these four columns into
0:25
just one column as you can see here
0:27
under concatenate function the under the
0:30
and operator under the text join so
0:33
let's get started and I'll show you how
0:35
you can do this in under 5 minutes
0:40
so to combine four columns into one
0:44
column in Ex using the concatenate
0:46
function what we going to do h click on
0:50
the first cell and then use the
0:58
uh click on it and then within the
1:01
bracket uh take the first name
1:06
and then use your a comma and then put
1:14
one of your quotation marks and another
1:17
one a space in between and then another
1:22
then let's go to the last name
1:28
comma and then your quotation marks
1:35
your quotation marks again
1:43
comma and then let's go to New York
1:49
comma quotation mark comma
1:54
space quotation uh quotation mark comma
2:00
and then uh USA and then click enter as
2:05
you can see what we've done now we've
2:08
combined John Smith and then we have New
2:11
York and USA which has been separated
2:14
using the commas and then you can drag
2:20
and as you can see everything has been
2:23
copied the way it should be
2:27
and everything has been combined in just
2:32
one column so that's how you do it using
2:35
the concatenate function so you can
2:38
alternatively use the and operator and
2:41
how we can use the and operator is you
2:44
just type in your equal sign select
2:49
now select your first name and then add
2:53
to it add the and sign the and operator
3:00
and then quotation marks
3:04
uh leave a space start with your
3:06
quotation mark again insert your and
3:09
operator and then click your last name
3:14
uh use your and uh your and operator
3:18
again and then finish it up with
3:21
quotation marks and then comma
3:25
start with the quotation marks again and
3:28
then your end operator click New York
3:41
comma space quotation marks again and
3:58
I missed the last one It should be
4:10
it's misbehaving because I should start
4:12
with an and operator and then click on
4:15
USA when that's done now as you can see
4:19
it's just the same as the first one John
4:23
Smith New York and USA and then you can
4:26
drag and drop and then this will be
4:33
so the last one we are going to combine
4:36
the four columns now using the text join
4:40
so for the text join you start with your
4:49
text join you start with your double
4:56
and then comma space quotation marks
5:00
again comma and then you're going to use
5:03
true uh so you can ignore so it can
5:07
ignore the empty cells
5:09
true and then comma and then select the
5:13
first two names because we want to
5:15
combine John and Smith at the same time
5:23
and then close it with your paren close
5:27
your parentheses use the and operator
5:32
close it with a quotation marks comma
5:36
a space then now start with your
5:41
quotation marks again your and operator
5:44
and then now click on the city
5:48
close it with your with the and operator
5:52
and then your double parentheses comma
5:56
space start again with a
5:59
double quotation marks click um do not
6:03
forget your end operator otherwise it
6:07
this behave then click on USA and that's
6:11
it and as you can see now we have John
6:17
uh John it separates John Smith New York
6:21
and USA but to correct this so we can
6:24
have something that's similar to the
6:26
rest um under this formula we can just
6:29
get rid of the first comma and as you
6:33
can see now it joins John Smith New York
6:36
and USA and then click and drag to fill
6:40
in uh the address so that's how you you
6:44
combine four columns in Excel using
6:47
those three different methods if you
6:49
have got a question please feel free to
6:51
leave it in the comment down section and
6:54
we will create a video for you otherwise
6:57
as usual thank you for watching and see
6:59
you again in the next video goodbye
