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.
Excel Tutorial For Beginners: • Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
_______________________________________
Excel - Auto Fill:
• How To Use Autofill In...
Excel Flash Fill:
• Excel Flash Fill Tutorial
How To Insert Rows and Columns:
• How To Insert Rows and...
Resize Multiple Rows and Columns:
• How To Resize Multiple...
How To Move Columns:
• How To Move Columns In...
_______________________________________
How To Move Multiple Rows & Columns:
• How To Move Multiple R...
How To Split Text Into Multiple Columns:
• How To Split Text Into...
How To Use Hyperlinks In Excel:
• How To Use HyperLinks ...
How To Sort and Filter Data:
• Excel Sorting and Filt...
Excel - Find and Replace Tutorial:
• Excel 2016 - Find and ...
Excel Conditional Formatting:
• Excel Conditional Form...
______________________________________
Relative & Absolute Cell References:
• How To Use Relative & ...
Lock Cells and Protect Sheets In Excel:
• How To Lock Individual...
Excel Interactive Checklist:
• Interactive Checklist ...
Excel Pivot Tables:
• Intro to Pivot Tables,...
______________________________________
KZread Channel Growth Accelerator:
/ youtubechannelgrowthac...
Final Exams and Video Playlists:
www.video-tutor.net/
Full-Length Math & Science Videos:
/ collections

Пікірлер: 29

  • @TheOrganicChemistryTutor
    @TheOrganicChemistryTutor6 ай бұрын

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

  • @ihekewilliams3643
    @ihekewilliams36434 ай бұрын

    Simple, Clear and helpful. Thank you

  • @sangeetapereira8565
    @sangeetapereira8565 Жыл бұрын

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

  • @n7276
    @n72763 жыл бұрын

    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)

  • @moritop.doronilajr.2639
    @moritop.doronilajr.2639 Жыл бұрын

    thank you so much, very helpful

  • @angelicamicayas3272
    @angelicamicayas32722 жыл бұрын

    Thank you 😊

  • @PunmasterSTP
    @PunmasterSTP2 ай бұрын

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

  • @isabar8056
    @isabar8056 Жыл бұрын

    tysm bro u saves my day

  • @teechbeta
    @teechbeta11 ай бұрын

    Thank you Buddy 🙂 👍

  • @RaviShankar-gm9of
    @RaviShankar-gm9of Жыл бұрын

    Excellent...

  • @DLCS-2
    @DLCS-23 жыл бұрын

    Thanks !

  • @jaysatya4341
    @jaysatya43412 жыл бұрын

    many many thanks sir

  • @sandraronke7876
    @sandraronke7876Ай бұрын

    Very helpful 🎉

  • @ShrayesBN
    @ShrayesBN4 ай бұрын

    Thanks bro it helped a lot.

  • @user-zk5yo1nh1v
    @user-zk5yo1nh1v Жыл бұрын

    I learned a lot

  • @Abhishekkumar-ri9wp
    @Abhishekkumar-ri9wp16 күн бұрын

    Great

  • @saifullahmahar3322
    @saifullahmahar33226 ай бұрын

    Thanks.

  • @raulleman2506
    @raulleman25068 ай бұрын

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

  • @diljeetdulay
    @diljeetdulay Жыл бұрын

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

  • @diljeetdulay

    @diljeetdulay

    Жыл бұрын

    Got it, paste special value. Cheers

  • @10X-Trivia-Sean
    @10X-Trivia-Sean20 күн бұрын

    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!

  • @aasthagoyal5059
    @aasthagoyal50592 жыл бұрын

    we need to do it for each row?

  • @20cm88

    @20cm88

    Жыл бұрын

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

  • @20cm88

    @20cm88

    Жыл бұрын

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

  • @edmundrodriguez7844

    @edmundrodriguez7844

    Жыл бұрын

    only comma used as space in the text

  • @ranjithkumarpodila1619

    @ranjithkumarpodila1619

    Жыл бұрын

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

  • @christyserna1604
    @christyserna1604 Жыл бұрын

    🎉❤

  • @DekooTemam-kj7zf
    @DekooTemam-kj7zf7 ай бұрын

    10q

Келесі