How to merge data from two different columns in Excel

This is a quick video I used to answer a question about how to merge data in two columns of an Excel spreadsheet. This solution uses the CONCATENATE() function in Excel to "merge" data from two columns into a third column.
You can also find written instructions about the Concatenate function from Microsoft's help center here: office.microsof...
MORE FROM SCREENCASTINGWIZARD.COM
Screencast training (beginner/advanced) - www.DigitizeYou...
Facebook: / screencastingwizardry
Twitter: / melaclaro
Blog post updates: www.Screencasti...

[@eunicetphillip6318]

I CRIED TEARS OF RELIEF AFTER THIS WORKED FOR ME. I AM SO GRATEFUL. YOU SAVED ME HOURS OF COPY AND PASTING.

[@TheSupraRegistry]

You just saved me years. I had to merge 45,230 cells. Thank you. From the bottom of my heart, thank you.

[@larrywalker8787]

it's 1:25am and just found this. You Sir are nothing but 1st Class / Top Shelf as us old geezers would say. You know you have nailed this lesson when someone like me can understand it. Been trying to learn Concatenate as a beginner. If you could see the SMILE on my face. Explained it in the most simplest language. Thanks Again.

[@BossRedRanger]

11 years later and this is still helpful. Thank you!

[@MannyInVa5]

"Concatenate" is my new word for the day. Thanks for making me smarter.

[@tomd.4784]

Smart man. There is a lot of paid solutions for this simple and bulletproof trick. A lot of ppl create monsters with VB and macros, a lot of them also confuses the crap out of it to eventually turn you into the paid ones. This is exactly how this so frequently needed and notoriously overlooked by microsoft developers can be worked around. - Thanks Mel

[@aprilroga4465]

OMG!!! You just saved someone on my team a WHOLE LOT of manual work!!! YOU ROCK!!!!

[@DeniseSonnenbergHB]

Mel has the most complete explanations of things that can seem so complex beforehand. Thanks Mel!

[@kyleriley9061]

Thank you, this is so easy. I searched for a while to find this; most people seem to mistakenly believe that you need plugins to do this, but I guess they just don't know how to use excel!

[@chazbgood]

Hey! Just wanted to say a quick "Thank You" for this video. I have been trying to do this forever and I mean forever... Thanks again!

[@lk4364]

Helped immensely. Easier to follow than the help button within Excel. Thank you.

[@jamesstewart6436]

Thank you! I almost gave up and started merging pairs of cells manually. You've saved me from insanity.

[@dric30]

Hey, Thank you !!! the best quick video to merge cells so far! I learned something powerful today!! Much Appreciated, Dave

[@JohnDavidBalla1927]

What a great video! You just compressed 4 days of work into about 2 hours!

[@tarlanahmadov5115]

Finally, someone explained it! Appreciated!

[@chrisariasnow]

You just saved me. I really appreciate this video but mostly I appreciate YOU, my good man.

[@enweremudochukwu8563]

Thanks a million. This saved me a whole lot of stress.

[@boootsncats]

wow this just changed my life honestly thank you

[@ryanlancaster5823]

You saved me HOURS. Really appreciate it.

[@holistic_therapist_success]

This was really helpful and clear, thank you

[@MikeLiddicoat]

Thank you so much. Did not know about the "Save Special" function, that is exactly what I needed. Thank you again.

[@TamiVroma1]

Awesome!!! Exactly what I was looking for...quick and to the point...wish everyone did these videos!!!

[@alexwebster9446]

Thank you so much been struggling with this for weeks. Only explanation I’ve understood!

[@agpoujol]

Bless you! Exactly what I needed. Don't get why merge cells doesn't work...but glad I found your video.

[@arstudio540]

Thank you so much you just complete my work within 3 mintues. Hands off to you man.

[@gestata897]

Great video. Very informative. As always, there is more than one way to get the cat 2 purr. Try this =B2&"easy way"&C2

[@billyvegas964]

This is Exactly what I was looking for. Thanks for the quick and simple examples. Well done!

[@abigailferris6013]

This was so straightforward and simple to follow! Great job. I'm off to see what else you have :)

[@monicawinter6967]

Thank you. This was very helpful and walked me through exactly what I needed to do to merge the columns on my spreadsheet.

[@gerod223]

I am not kidding. If I ever meet you I am going to give you a hug. Not a weird one but there is no escape... hug. Thank you!

[@ellenfox2180]

Super easy to follow - thank you!! I just saved hours of work!

[@Zamira12]

THANK YOU!!!!!! I have thousands of data points, it will have take me days!

[@mjhornidge]

Dude!!! Super helpful even now in 2020. Thanks!!

[@saibamedical1699]

THANK YOU SIR, FOR THE WONDERFUL HELPING LESSON.

[@BezVBerry]

Really helpful and straight to the point. Thank you.

[@bubblegum9826]

Thank you that was so helpful and awesome! Really helped with my assignment. I Love you

[@AbuMazharKhalidSiddique]

Thank you Mr.Mel Aclaro for this kind of best solution I really appreciate to you and your team for the best efforts. god bless you. !!!!

[@davidhawaii9797]

I just spent 6 hours typing out my cells. about 4 hours into it I thought i would look. I didnt want to waste the hours, so I finished, and then found your video.. Daaaam! I knew it was possible.. Crap!
thank you so much..

[@zombiehunter1977]

Thanks, that was super simple and saved me a ton of work! So much better than excels help function which might as well be written in latin.

[@amykennedy5692]

This was great, just what I needed, especially with the added dash. Thank you!

[@mikesyourman6205]

wow. that sure saved me some time. no one I knew could help. need to hang around with smarter folks...

[@nobacardi4Lizzz]

Best explained so far

[@rajarajeswari2236]

Thank you so much!!this is so much easier than macros and indirect functions.

[@jatinsheth4124]

Thank You Mr. Mel Aclaro

[@NeeruNiranjan]

Wonderful, it saves my time a lot.

[@janVart2wear]

THANK YOU for this. I've tried to figure out how to do this forever!

[@JustinLauu]

EXACTLY what I was looking for and MORE, THANK YOU!

[@ArdenBarlow]

This was incredibly helpful--thank you!

[@dryleaves1347]

I was looking for it
That actually helped
Thanks allot 😃

[@isyis7861]

You are seriously the man

[@jeanmariedavel1722]

Awesome!! Quick and gets to the point thank you

[@planobaseballassociation7941]

Very clear and informative video, thanks for sharing!!

[@valjazz]

Thanks for posting this, it was a lot of help.

[@JamesOutlandJr]

This is what we needed today! Thank you

[@shyamalbanerjee64]

GOOD DEMO. FOUND TO BE HELPFUL.

[@qaibas]

Very helpful :)
If you need to put comma or space in there, just put it in quotes jike "," and " ".

[@eGazTheFirstAustralian]

Thank you soo much. Still relevant and great

[@dapidizme]

so glad i found this. Thank you!!

[@jdstarek]

You never answered the actual question that you pointed out at the beginning of the video. How do you combined the columns and overwrite only the empty cells....that was the question...

[@stanbri3262]

You saved my butt! Thank you very much!

[@rebeccaheredia4448]

Very helpful and simple! Thank you!

[@thesibbiesshow]

Thank you so much sir! you made my day!!!!!!

[@tonygirard3307]

I already tried this before I saw this. I probably missed a step. Thanks for the help.

[@rafayhaq6570]

Very helpful.
Thanks a lot you are making lives easier here. :)

[@Dr.Fr-grant369]

Thank you soo much ws soo helpful u save me time 🎉

[@ernieb7725]

Very helpful and informative video! Thank you!!!

[@MelAclaro]

@ghishgirl - You're so welcome. I'm glad it helped! :) Thanks for watching.

[@gideon2109]

Thank you so much. Worked like a champ

[@ghishgirl]

Really appreciate your explanations Mel, thank you!

[@reeseoroni]

psyche! this is an awesome and very helpful tutorial. THANK YOU!

[@thanasislondon]

Thanks! you're a star your post really helped.

[@rosemarymachado8749]

What life saver!! Thank you so much!!

[@juzercheck]

thanks for the help made a very tuff task very easy for me.

[@MelAclaro]

Hi @jessthecoyote Re: ur question, you'd do the same procedure as 1:50 in the video. But just replace the hyphen with a period. (Make sure to put the period in quotes.) e.g., =Concatenate(A1,".",B1) Alternatively, you can use =A1&"."&B1 Like that. 'Hope that helps!

[@sanjayjaiswal4261]

It is working same as he did. but this is easy to memorized.

[@pallavilovely8585]

Thank you

[@SanjeevMalik2]

Thanks Mel for the explanation.

[@janinegrobbelaar]

Thank you for this. I have another question... I merge the data of two columns on Sheet A to a column on Sheet B. But when I want to copy the formula to the next row it doesn't copy the next row. Only the first row. Please help

[@JamieJeanRivkin0312]

This is REALLY helpful!

[@write2swapnil41]

Best!! I was looking for this formula...

[@liztyler4312]

Thank you SO much , very well explained and works !!

[@robert8051]

Thank you very much, you saved my time..

[@muhammadghufran9481]

Very Helpful.
Thanks.

[@sorayasmith478]

How do I apply that to the entire column as opposed to dragging if the column is thousands long?

[@cindylesperance1460]

So helpful! Thank you!

[@dr.leetalkingskincare4765]

How can I remain the same format from the previous cells that I selected after using concatenate() function, instead of changing the format into number or general?

[@armaansood2081]

extremely helpful , thanks!

[@Eyanlakhani]

Hey Mel: This video was useful. Thanks for sharing !

[@Benjamin-gp3dl]

Yes great but I can’t get rid of the original two columns without losing the new column?

[@MelAclaro]

Matt - Yes! I agree. Your shortcut is MUCH better. Thx for sharing the tip. :)

[@RetroBroYo]

YOU. ARE. THE. MAN!

[@MrDeanbojangles]

Thank you! You have saved me hours!

[@subhashinim111]

Great Video! Thanks

[@kaminilamba2166]

Tnq so much..vry informative session

[@Clifford1under]

Thanks. you made it so easy.

[@debrahurst9684]

Exactly what I needed. Thank you!!

[@fastrackcourier6763]

this should have a million likes

[@alishaikh4386]

Doesn't work with numbers with 00 at the beginning of either of the numbers in any cell.
Eg: 123 and 001
The formula omits the 00 in the output, any thoughts?

[@rayapudide]

Thanks a ton, you have solved my problem.

[@srijit8227]

Great Help...thank you ..

[@chefSqueez]

it all made perfect sense. Thank you

[@laurasisk8494]

Thank you so much! This was so helpful.