Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741

Learn how to.
1. (00:00) Introduction
2. (00:04) TEXTJOIN function.
3. (00:34) ARRAYTOTEXT function to deliver text separated by commas. If no empty cells, this method is faster.
4. (01:00) When TEXTJOIN to join is better. If you need to avoid empty cells, TEXTJOIN is best.
5. (01:13) ARRAYTOTEXT to deliver items in array syntax.
6. (01:58) ARRAYTOTEXT knows data types!!!!!!
7. (02:03) Old School F9 to deliver a hard coded array.
8. (02:27) Summary, Closing and Video Links

[mueez]

BAM! Always something new to learn from you! Stay blessed!

[bipower]

Didn't know about ARRAYTOTEXT. Great one!

[maneshzaveri]

A quick 3 minute lesson from you gives me a life time of knowledge. Knowtow to you

[bamakaze]

Array-to-text is my new thing to show off at work! Be like Mike!

[frankabacus]

Mike, you just make Excel do your bidding with fun and ease! Astonishing.

[OzduSoleilDATA]

HOTDOG! I've gotta play with this.
Thanks for letting us know. BAM!🔥🔥🔥

[HusseinKorish]

Those bonus tips ...that i always await for ... thanks Mike

[billywiswall]

Once again you have given us a great education, thank you Mike!

[mr.brownstone]

BAM! Love the new formula and forgot Textjoin has the ability to skip blank cells. Muchas gracias!

[DucNhan]

Thank you for your excellent video, as usual, hope to see more! have a great day.

[wayneedmondson]

Awesome Mike! ARRAYTOTEXT.. BAM!! Thanks for the Tuesday text function fun :)) Thumbs up!!

[ljubicar]

This Arraytotext function will come handy when writing script for inserting values into SQL from data stored in Excel. Looking forward to try this.
Anyway, still miss the old intro when you introduce yourself and greet us.😔

[EricHartwigExcelConsulting]

Thank you for sharing/creating this video so awesome!

[மின்விரிதாள்_விரிப்போம்_வாங்க]

Super cool. Your videos are to the point and precise!

[spilledgraphics]

As always, small but greatly relevant theory to always have in mind on minute 01:25 ! 🔥🔥🔥🔥 Thanks Mike !! #GoTeam !!!

[Softwaretrain]

Woow😍😍😍. Thanks.
Missed you a lot.
Big like.
Really informative.
Hope you are better regarding your pain in back.
Except textjoin others was new for me.
Also thanks for bonuses.

[vaibhavgond]

BAM! This is awesome Mike!! Thanks for sharing.

[KevinPGA]

ExcelIsFunToLearnNewCommands!

Thank you Professor. Very cool!!! For some reason it reminded me of the old 4th Dimension Programming days back in the 90’s, only I think it was ArrayToText. Could be wrong… 😃

[darrylmorgan]

Boom!Simply Put "AWESOME"...Thank You Mike :)

[ennykraft]

Thank you for telling us about this new function. Now all we need is for Microsoft to realize that countries which use commas as decimal separator (i.e. most of Europe and south America) and therefor use a semicolon in functions nevertheless use commas for a list like this. Here in Germany you get Coke; Chips; Burger Buns … It's easy to change with the SUBSTITUTE function but that's annoying.
Could you please also do a video for VALUETOTEXT cause I'm baffled what we might use it for?

ETA: I had fun playing around with the new function and realized that it can be used to get all the results from the FILTER function into a single cell.