TEXTJOIN function: How to Display Split Array Data in One Cell | Excel Tutorial
Learn how to effectively use the TEXTJOIN function in Excel to showcase split array data in a single cell. In this beginner-friendly tutorial, we explore the powerful capabilities of TEXTJOIN when combined with dynamic functions like FILTER. Upgrade your spreadsheet skills and discover the step-by-step process to optimise data display. Watch now and take your Excel knowledge to the next level!
0:00 Introduction
0:38 What is the challenge of displaying dynamic data in split arrays?
2:22 The solution
3:39 Conditional formatting the result
3:57 Testing the result
TEXTJOIN is really intended (along with CONCAT) to replace the CONCATENATE function and using the & symbol. TEXTJOIN is really the most useful of the two, as discussed in a previous video: • Functions to join text together: CONCAT an...
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 3 - ...
Or check out the following video:
You'll find information on CONCATENATE in my formulas and operators video: • FORMULAS and OPERATORS: Learn the basics o...
Other popular videos
Drop down lists: • Excel Basics: EXCEL DROP DOWN LIST - a 'ho...
UNIQUE function: • Video
XLOOKUP: • What is XLOOKUP and why is it a good alter...
Named ranges: • Naming data in excel and how to use in for...
Using named ranges and XLOOKUP together: • XLOOKUP & Named Ranges: use them together ...
Filter with multiple criteria: • FILTER function. How to use it with multip...