Functions to join text together: CONCAT and TEXTJOIN (Excel tutorial for beginners)

Опубликовано: 14 Январь 2025
на канале: Bitesize Excel

211

This video looks at two functions that were added in Office 2019 that help you join text together. These are intended to replace the CONCATENATE function and using the & symbol. The two functions are CONCAT and TEXTJOIN. I find TEXTJOIN the most useful of the two. This easy beginners tutorial will help bring your spreadsheet knowledge up to the next level.

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

Check out our playlist on inputting, viewing and managing data:    • FREE Excel course for beginners: Week...

Or check out the following video:
You'll find information on CONCATENATE in my formulas and operators video:    • FORMULAS and OPERATORS: Learn the bas...

Other popular videos
Drop down lists:    • Excel Basics: EXCEL DROP DOWN LIST - ...
UNIQUE function:    • Video
XLOOKUP:    • What is XLOOKUP and why is it a good ...
Named ranges:    • Naming data in excel and how to use i...
Using named ranges and XLOOKUP together:    • XLOOKUP & Named Ranges: use them toge...