Get Started With Excel TEXTJOIN Function
In Excel for Office 365, or Excel 2019 and later versions, you can use the TEXTJOIN function to combine text from multiple ranges, quickly and easily.
This is much better than the old methods of combining text with the CONCATENATE function, or the ampersand operator.
In this video, see how to us the new TEXTJOIN function to quickly combine the weekday names from 5 cells. The day names are separated by commas.
Then, see how to add formatting to the combined values, when joining a list of dates with the TEXTJOIN function. Without that formatting, the list shows numbers, instead of easy-to-read dates.
Download the free Excel workbook on this page:
https://www.contextures.com/xlCombine...
Video Timeline:
00:00 Introduction
00:25 Old Way to Combine Text
00:54 TEXTJOIN - List of Days
02:20 TEXTJOIN With Formatting
02:48 Named Ranges
03:50 Get the Workbook
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips
Смотрите видео Get Started With Excel TEXTJOIN Function онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Contextures Inc. 02 Сентябрь 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3,54 раз и оно понравилось 6 людям.