How to Merge Data From Multiple Columns Using TextJoin & Concatenate Functions | Excel

This video tutorial explains how to merge data from multiple columns in Microsoft excel using the textjoin and concatenate functions as well as another simple formula.

Top 30 Excel Tips & Shortcuts:

_______________________________________
Excel - Auto Fill:

Excel Flash Fill:

How To Insert Rows and Columns:

Resize Multiple Rows and Columns:

How To Move Columns:

_______________________________________
How To Move Multiple Rows & Columns:

How To Split Text Into Multiple Columns:

How To Use Hyperlinks In Excel:

How To Sort and Filter Data:

Excel - Find and Replace Tutorial:

Excel Conditional Formatting:

______________________________________
Relative & Absolute Cell References:

Lock Cells and Protect Sheets In Excel:

Excel Interactive Checklist:

Excel Pivot Tables:

______________________________________
YouTube Channel Growth Accelerator:

Final Exams and Video Playlists:

Full-Length Math & Science Videos:

[sangeetapereira]

Thank you so much for sharing very useful and helpful. God bless you

[n]

You're very intelligent with Excel and I learned a lot. Thank you! I do believe it would have been easier for a newbie like me if you saved the concatenate method second as the second way of doing it was way easier to learn. Thank you again. :O)

[PunmasterSTP]

Concatenate? More like "Cool videos that are great!" 👍

[raulleman]

If we delete old new one also deleted, when we make this

[X-Trivia-Sean]

this worked for me in Google Sheets too, BUT when I try to copy/paste it i get a #REF! Data Does Not Exist error...any idea how to copy it once done? I work on monthly schedule flyers and this will save me a ton of time/hassle if i can figure it out!

[diljeetdulay]

How do I copy the combined data to another sheet as when I do it, it looks for the formula