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

[@TheOrganicChemistryTutor]

Final Exams and Video Playlists: www.video-tutor.net/ Full-Length Math & Science Videos: www.patreon.com/mathsciencetutor/collections

[@eudoxeya]

This was exactly what I was looking for and the additional methods are super helpful. Thank you.

[@ihekewilliams3643]

Simple, Clear and helpful. Thank you

[@n7276]

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)

[@ShrayesBN]

Thanks bro it helped a lot.

[@isabar8056]

tysm bro u saves my day

[@JeremyJamesMiralo-f5d]

Thank you Brother!

[@PunmasterSTP]

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

[@sangeetapereira8565]

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

[@sandraronke7876]

Very helpful 🎉

[@akhilrajtm5024]

Very much helpful

[@moritop.doronilajr.2639]

thank you so much, very helpful

[@teechbeta]

Thank you Buddy 🙂 👍

[@RaviShankar-gm9of]

Excellent...

[@TINSAEWORKU-t4i]

I learned a lot

[@jaysatya4341]

many many thanks sir

[@saifullahmahar3322]

Thanks.

[@raulleman2506]

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

[@angelicamicayas3272]

Thank you 😊

[@DLCS-2]

Thanks !

[@shishirdongare6197]

THANKS

[@10X-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!

[@Abhishekkumar-ri9wp]

Great

[@diljeetdulay]

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

[@diljeetdulay]

Got it, paste special value. Cheers

[@ShreemallikarjunaMS21]

Not working with numbers and alphabetical

[@TEAtimesTHREEE]

I figured it out thanks to Google lol "Make sure that the cell where you are entering the CONCATENATE function is formatted as General. If it is formatted as Text, Excel will not be able to combine the text from the different cells. Step 2. Make sure that the Show Formulas button is not selected." My column was formatted as text so no functions were working omg!

[@aasthagoyal5059]

we need to do it for each row?

[@20cm88]

No You can do it for one row and then use autofill for the rest

[@20cm88]

No You can do it for one row and then use autofill for the rest

[@edmundrodriguez7844]

only comma used as space in the text

[@ranjithkumarpodila1619]

It's not applicable each row.... Is there any formula

[@christyserna1604]

🎉❤

[@DekooTemam-kj7zf]

10q