Combine Text in Excel | Using Concatenate Function 

🎓 Learn advanced excel with our complete excel training course: eduolio.com/ex...
How to combine cells in excel using concat function in excel quickly:
1. Syntax is =A2&B2 or =CONCAT(A2,B2)
2. This will combine text in excel from cell A2 and B2.
3. To add a space between A2 and B2 use =A2&" "&B2 or =CONCAT(A2," ",B2)
Voila, you know how to join text in excel using concatenate function in excel.
If you want to learn more excel concepts like pivot tables, dashboards, vlookup, IF formulas, conditional formatting, macros etc. Then checkout our advanced Excel course with over 10+ hours of content, 50+ exercises, doubt support and much more.
Excel Pro+ Course ► eduolio.com/ex...
🚩Follow us on:
Instagram: / eduolio
Website: eduolio.com
#excel #exceltips #exceltutorial #microsoftexcel #tutorial #microsoftoffice #googlesheets #exceltricks #tech #learn