ARRAYTOTEXT() Function Excel - 5 Practical Examples

[@Tattysnuc]

What I took from this is the unique function. Genious. Cheers.

[@TeachExcel]

I'm glad I could help :) It makes me think that I should flesh-out that example a bit more as it really does make life so much nicer now.

[@jackcurl2005]

@@TeachExcel And combining UNIQUE and SORT in one statement is pretty helpful, too. MS is moving more and more database functionality (the "what I want" vs "how do I get what I want", or declarative vs procedural) into Excel. Abstraction is a good thing. Now, if Microsoft could incorporate Power Query into Access and make its interface less klunky (stop reformatting my SQL into an unreadable mess!), that would be killer. One can dream.

[@TeachExcel]

This is a beta function for Excel 365 I found yesterday and thought it was interesting. Let me know if you have any other uses for it :)

[@darrylmorgan]

Cool Tutorial,I Have Never Used ARRAYTOTEXT() So Just Learned A New Fuction...Thank You Sir :)

[@TeachExcel]

I'm glad I could show you something new Darryl :)

[@Fxingenieria]

Excellent !!!

[@IvanCortinas_ES]

Excellent tutorial. How long has it been in operation? Thank you!

[@TeachExcel]

Thank you! You're very welcome Ivan :) You know, this is funny because I did some digging and it seems to have been released last year, or maybe earlier, for some people, and it seems like they had bigger plans for it relating to newer data types, but maybe they just put that stuff on the back-burner but left this guy in there. I found the function by accident this week.

[@IvanCortinas_ES]

@@TeachExcel I did not know about this function. A lot of LET, a lot of LAMBDA and then you come across this feature! My face was like I had landed on planet Earth.

[@AaronHernandez-xv4qh]

This is great stuff!

[@TeachExcel]

Thanks! I'm glad you think so Aaron :)

[@AaronHernandez-xv4qh]

@@TeachExcel any guesstimate on when the macro/vba course will be complete? Waiting patiently, excited for that to come out.

[@TeachExcel]

I really appreciate that Aaron! I have learned to not make another prediction, but I have finished all of the big stuff, and now am in a video editing phase and adding intros to every section. There is a chaaaaance that I made the course a little comprehensive, but I must say that I am very happy with it and I think once someone takes it, they will feel comfortable tackling any task in vba. Once again, I am very sorry that I have not been able to meet my deadlines for publishing it!!!

[@cazmaj]

Thanks, great tutorial. Subscribed and will have a look through some of your other vids :)

[@rafeehelmy4405]

This video is amazing , thank u

[@wayneedmondson1065]

Interesting! Thanks for sharing this :)) Thumbs up!!

[@kolavithonduraski5031]

you could use it in VBA maybe... maybe to convert data to collections (unique keys) or arrays. with worksheetfunction.unique() or worksteetfunction.arrayToText() especially when it is data you just need in one cell, separated with comma or semicolon. 👍 Thanks.

[@TeachExcel]

Definitely liking your thoughts on using it in VBA! I also think Excel was or is planning to use it for something else that is not yet fully implemented.

[@micheltremblay8184]

Thank you very much, your videos are very informative for me and you have a calm voice. But you keep moving your mouse in circles and it makes me dizzy, :) Have a nice day

[@TeachExcel]

Oh I'm sorry about that! I actually thought that would make the videos better for people - I will try to be less spastic with my movements.

[@vikaasb2016]

Awesome

[@TeachExcel]

Thanks Vikus! :)

[@Rio_Rioz]

Great! Только как часто и где на практике необходимо заменять массивы на текст в строчку..?

[@TeachExcel]

English is easier for me, but I think i got it lol - I'm not sure how useful this function will be going forward compared to textjoin, it depends what they do with it. But combining a range into a single cell for output is quite useful as a future tutorial will show you regarding outputting slicer selections in a single cell.

[@erikguzik8204]

"Excel"lent..!!! just a quick note, when you want the column in a table i.e. Table[Mrf]. hover just above the column header and you will see a thick black down arrow. Click and you will insert the table column into your formula. Makes it much easer when you have 1000's of rows of data.

[@micheltw]

How did you find that beta function?

[@TeachExcel]

I was just messing around with arrays and looking for functions that might be new to slice and dice them like you can do in vba and found this guy and investigated what it was. I not sure they are even planning to keep this in there as almost no mention of it is made online beyond a very basic usage.

[@abbottkatz8830]

Couldn't you also write =ARRAYTOTEXT(H23#)?

[@gamestertrader3047]

Hi stamble to your video tutorial Im looking for a formula and how to set up to the output. I want Letter separated per cell Pattern 1: LWLWLWLWL Pattern 2: LLWLLWLLW Patter 3: WWWLWWWLW Patter 4: LLLLLLLLL Pattern 5: WWWWWWWWW Results LLWLWWWWWLWWLLLLWWLWLWL--- What I want is to predict the possible letter that will come out next base on the establish pattern. i hope you can give me a guide

[@arijitpaul2751]

cost for workshop

[@paulhetherington3854]

1= the whole - system! 2= tiny ()-call - you have - zero array.