Combine Two Columns in Excel Using CONCATENATE or CONCAT Formula

Transcript

00:00Hi everyone, in this video I will guide you to combine two columns in excel using concatenate

00:07or concat formula.

00:11So with the concate you need to type is equal to and type concatenate and then open the

00:26bracket and this is the first cells you want to combine comma spacebar and quotation double

00:40quotes space double quote but this is a space character inside quotation mark it tells excel

00:48to put a space between the values of two cells comma space and the second cells which you

00:57want to combine and hit close the bracket and hit enter and this is what you can easily

01:05combine two columns easily with the concate formula and just drag it and you will see the

01:14both the text and values are combined in the third columns.

01:21So how you can do that with the concat formula type is equal to concat bracket upon and select

01:33the first cells comma space double quote space double quote space and select the second columns

01:46and bracket close and hit enter.

01:50I forget to put the comma here so hit enter.

01:58So now you can see that the both columns are combined.

02:06So in this way you can easily combine two columns in excel using concatenate or concat formula.

02:13If you think this video is helpful please support my channel thanks for watching.