×

LearnMania's video: Use TEXTJOIN function in Excel- Smart Solution using a real example

@Use TEXTJOIN function in Excel- Smart Solution using a real example
Assume that you have a list of items for many orders, and you need a formula to get the item numbers for each sales order separated by comma. The smart solution is to use TEXTJOIN function! Six new calculations have been added since last year for Office 365 subscribers. One of those, the TEXTJOIN function, is proving to be more flexible and more powerful than it originally appeared. When TEXTJOIN was introduced in 2017, it seemed like Microsoft was trying to improve deficiencies in the CONCATENATE function. But there’s more to it.

18

1
LearnMania
Subscribers
25.7K
Total Post
25
Total Views
1.2M
Avg. Views
38K
View Profile
This video was published on 2020-03-13 16:54:55 GMT by @LearnMania on Youtube. LearnMania has total 25.7K subscribers on Youtube and has a total of 25 video.This video has received 18 Likes which are lower than the average likes that LearnMania gets . @LearnMania receives an average views of 38K per video on Youtube.This video has received 1 comments which are lower than the average comments that LearnMania gets . Overall the views for this video was lower than the average for the profile.

Other post by @LearnMania