👉 Become an Excel Rock Star in just a few hours with our "Microsoft Excel - From Beginner to Pro" course: https://bit.ly/4gHGZy0
In this video, you’re going to learn how to use the CONCATENATE and CONCAT functions in Excel to combine text strings. We’ll explore:
How the CONCATENATE and CONCAT functions work to join text from different cells.
The key similarities and differences between the two functions.
Tips for deciding which function is best for your needs, including how CONCAT improves on CONCATENATE in modern Excel versions.
By the end of this tutorial, you'll know exactly when and how to use each function.
⬇️ DOWNLOAD THE EXCEL FILE used in this video: https://bit.ly/4dBedfU
📰 JOIN OUR NEWSLETTER Join to get free Excel tips, tricks and exclusive course discounts:
🔔 SUBSCRIBE to this channel: / @mark-cunningham
⌚ TIMESTAMPS
00:00 Difference Between Excel CONCAT vs CONCATENATE Functions | How and When to Use Them
00:46 CONCATENATE function
02:14 CONCAT function
03:04 Difference between CONCAT and CONCATENATE
05:18 CONCAT and CONCATENATE with spaces
06:58 CONCAT and CONCATENATE with special characters
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚖ DISCLAIMER
Information provided in our videos does not constitute financial, taxation, legal, business or other professional advice. If you make a purchase through an affiliate link provided here we may receive a commssion. We do not accept any responsibility or liability for purchases made through third-party vendors, websites, or services. It is your reponsibility to review and understand the terms, conditions, and policies of third parties before making any purchases.
Watch video DISCOVER the REAL Difference Between CONCAT and CONCATENATE in Excel online without registration, duration hours minute second in high quality. This video was added by user Mark Cunningham 08 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 132 once and liked it 7 people.