My Take on solution 6 with a lambda function .. A bit verbose thought and not as elegant as yours. = LET(toreverse,H234:H253, Result, BYROW(toreverse,LAMBDA(x,CONCAT(LEFT(RIGHT(x,SEQUENCE(LEN(x))))))),Result)
as there are probably a lot of folks out there that are using Excel in their native language (aka 'my colleagues') that would benefit from this, can I advocate for 'other language' teams (translating the cases and the tutorial)? I'm willing to participate in the Dutch one 😀
That’s a great idea! I’m guessing we could automate a pretty decent job of translating the instructions, except that we’d need to be careful with function names. But I’m sure we can also find a table of function names and translations to help with that…
@@DimEarly what I like about your play-throughs is that one can follow along, but when there are too many things to translate, they will check out. It's not only function names, but there is the fact of the delimiter in functions "," vs ";". And although I have English Excel at home, I still have the ";".
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
I love this stuff. I do a lot of breaking apart and recombining text in my queries. This helps a ton. You’re a master. Love your content. Thank you.
Thanks Joel - glad to hear you found it helpful!
Thanks Dim. Always looking for good practice.
Thanks! All credit to Harry for coming up with this though…
Thank you for sharing !! Excellent text function exercise.
Awesome training.
I totally agree - Harry did a really nice job with these.
Dim: Great exercised to start off the year. Happy new year!
My Take on solution 6 with a lambda function .. A bit verbose thought and not as elegant as yours. =
LET(toreverse,H234:H253,
Result,
BYROW(toreverse,LAMBDA(x,CONCAT(LEFT(RIGHT(x,SEQUENCE(LEN(x))))))),Result)
as there are probably a lot of folks out there that are using Excel in their native language (aka 'my colleagues') that would benefit from this, can I advocate for 'other language' teams (translating the cases and the tutorial)? I'm willing to participate in the Dutch one 😀
That’s a great idea! I’m guessing we could automate a pretty decent job of translating the instructions, except that we’d need to be careful with function names. But I’m sure we can also find a table of function names and translations to help with that…
I do know that they are being translated into Portuguese
@@DimEarly what I like about your play-throughs is that one can follow along, but when there are too many things to translate, they will check out. It's not only function names, but there is the fact of the delimiter in functions "," vs ";". And although I have English Excel at home, I still have the ";".
@@DimEarly @excelrobot I'm pretty sure OA Robot can do the function name translations
Great Video! This is everyone’s chance to beat the Lebron James of Excel. Try the case and get bragging rights
I thought that nicely demonstrated the value of the flexiquiz practice as well as the function practice! 😂