Grab the file I used in the video from here 👉 pages.xelplus.com/new-functions-file (requires Office 365)
@gvinodnair
2 жыл бұрын
Leila, any clue how to separate individual characters in the words to different columns? Which technique/ formula can be used?
@Hamza-yv6uy
2 жыл бұрын
Really appreciate all your contents , i would just to know how can i found them ? my version : Microsoft® Excel® for Microsoft 365 MSO (Version 2205 Build 16.0.15225.20278) 64-bit
@rudiansyahsyah9738
2 жыл бұрын
classroom speak extention basic symbol room commonecation software quality utility year 2022 / 2023 🏛🌍🌎🌏
@rudiansyahsyah9738
2 жыл бұрын
classroom speak motivation presentasi sys data com master extention room commonecation software speak english 🏛🌍🌎🌏🏛🏪🏬🏭🏯🏰💒🏩🏨🏧🏦🏥🏤🏣
@rudiansyahsyah9738
2 жыл бұрын
classroom speak basic symbol room speak english quality utility desktop end laptop motivation presentasi year 2022 / 2023 quality in sys data com master ecosystem personal classroom good presentasi you commonecation software microsoft logo end hardware the internet.com master parent Xxelplus label in diskcover desktop end laptop the txt generation monitoring windos |"m FTK studyn school computer index presentasi in speak english ok 🏛🌍🌎🌏
@MrSupernova111
2 жыл бұрын
For those of us who have been using Excel for many years and were forced to learn long and complicated functions, including array formulas, these new functions are mindboggling! Thanks!
@stenionet
2 жыл бұрын
I am using Excel since 1997 and now I am using office 2007. I hope to upgrade soon.
@bxyhxyh
2 жыл бұрын
@@stenionet wow.
@JJ_TheGreat
2 жыл бұрын
@@stenionet I was using Excel 2007 for a long time. When Office 2021 came out, I finally upgraded. I am happy I have some of the new dynamic array formulas - but I will probably get jealous of these new formulas. At least I still have Power Query to be able to manipulate data - which is a lot better than using the old, long formulas - especially the old array formulas.
@MrSupernova111
2 жыл бұрын
@@stenionet . Bruh...! lol
@mattschoular8844
2 жыл бұрын
@@stenionet Please confirm Office 2007 will run on my Commodore 64.... Just kidding... For $129 USD, we share an MS365 subscription within our company. It is so worth the annual spend
@kickthesky
2 жыл бұрын
The CHOOSECOLS function is going to be awesome! This makes doing FILTER SORT tables even better because I won't have to create staging tables that only include the data I want to show in the filtered and sorted table. I can easily create a subset of the original data and display only what I want to display. Such a game changer!
@leechrec
2 жыл бұрын
Daaaaaayyyyyuuuuuummmm bruh! Never in my life did I ever think I would be excited about Excel functions but these are dope!
@LeilaGharani
2 жыл бұрын
That they are 😁
@electroone8281
2 жыл бұрын
I totally concur with this. I took up learning VBA due to a lot of these types of formulas missing from Excel. Glad to see them continuing to add to the collection of Formulas in Excel.
@ericm9305
2 жыл бұрын
😂
@jg9353
2 жыл бұрын
You ain’t lying!
@ivanvukovic5108
2 жыл бұрын
This is how you know you grew up
@gvinodnair
2 жыл бұрын
These functions were just introduced yesterday by the great Excel development team to the Office insider community. Although I have seen a few other early bird MVPs introduce this function to the audience, I haven't seen anyone who explained it in an easy-to-understand way like you Leila. As always you have presented outstandingly well and concisely. Keep it up!
@juanrsosa
2 жыл бұрын
Totaly agree!
@saberarami123
2 жыл бұрын
what do I do to include them in my office 2021?
@Hamza-yv6uy
2 жыл бұрын
How can i found them ?
@jayholm9504
2 жыл бұрын
Thank you for presenting these new time saving functions. As always, you explained them so well with real world examples of how we might apply them. You are a Master!! Thank you
@LeilaGharani
2 жыл бұрын
You're very welcome!
@donald-parker
2 жыл бұрын
I get the value of the new functions, especially targeted at non programmers, but it would be nice if they added formal regex support. I've had my own UDFs for regex for several decades, but it would be nice if it came "out of the box"
@ktalwandi
2 жыл бұрын
You are amazing, Leila. Your course on VBA made me fall in love with programming and I nailed two interviews yesterday. Python was super easy to learn after VBA and now I can finally see some hope in my life. Thank you so much.
@LeilaGharani
2 жыл бұрын
That's great to hear!
@Sekoleyte
2 жыл бұрын
Where is her vba course? Are there any video in youtube. If you can share it, i will be thankful
@LeilaGharani
2 жыл бұрын
Right here: courses.xelplus.com/p/excel-vba-excel-macros
@stuartkay1393
2 жыл бұрын
Out of curiosity, how long did it take you to learn VBA? And then subsequently Python? It's something I've avoided up until recently but it would be good to put into perspective the time frame I'm looking at
@ktalwandi
2 жыл бұрын
@@stuartkay1393 depends on how much time you're willing to spend. I don't have a life and enjoy pace learning and I was able to complete VBA in less than three weeks. As for Python, I am still learning it and it has been about two months and I can say that I am at intermediate level. If you have never done any sort of programming, it might take you more time. Don't tell Leila but I've skipped the capstone projects in her VBA course lol. 😂
@knotingo
2 жыл бұрын
I’ve made a table a few days before and i even thought “this have to be done much easier” and now there it is! :-) Hope the update will be installed soon on my business devices. Thanks for this “breaking”! 👍
@MrSupernova111
2 жыл бұрын
You can already do much of these tasks without functions in Excel using the options in the Data tab and Power Query. Also, as Leila mentioned, some of these functions are just replacing older functions which can also get the job done but aren't always as flexible. Depending on your level of expertise most of these new functions are just a niche.
@devonbradford9217
2 жыл бұрын
A bit arrogant to call these niche. Most Excel users dont work in power query but their business needs would value these new formulas, without having to have expert excel/BI skills.
@mrCetus
2 жыл бұрын
OMG! What an amazing "array" of array functions! Can't wait to have them generally available! BTW, difficult to choose a favourite yet, because for now all seem to be equally useful! Thank you Leila for this nice demo with clear explanation!👌👍
@bijuraveendranathan8629
2 жыл бұрын
Madam, Fantastic.... May I know how could I get these new functions added to my Office 365?
@keijo456
2 жыл бұрын
I've been waiting for these Textbefore and Textafter functions! No more tedious left, right and mid! Thank you Leila for letting us know!
@mmohon
2 жыл бұрын
Can we get a textbetween too?
@vijayarjunwadkar
2 жыл бұрын
OMG! What an amazing "array" of array functions! Can't wait to have them generally available! BTW, difficult to choose a favourite yet, because for now all seem to be equally useful! Thank you Leila for this nice demo with clear explanation!👌👍
@hockeyfightjudge1
2 жыл бұрын
Excel's recent(ish) developments have been AMAZING. Xlookups, dynamic arrays like unique/filter, upcoming searchable auto-completing lists. And now text split and choose cols, which will have many use cases! Super exciting. Please Excel team: dependent dropdowns / multiple dependent dropdowns??
@learningtechie2964
2 жыл бұрын
Waiting for google sheets to bring these in too .. had used excel formulas for over 15 years , but just 2 years back realised how much more powerful google sheets is ..
@JimFikes
2 жыл бұрын
I agree, at first glace, TEXTSPLIT will be the first new function that I can easily integrate into my regular routine. Thanks, Leila, I heard about these new functions but waited for your video. You always do a great job of adding simplicity and clarity to everything related to Excel.
@jscomputergenius3834
2 жыл бұрын
Leila, any clue as by when we will have these new functions?
@harshitsharma7998
2 жыл бұрын
Amazing 😍😍and Great functions and always your great explanation
@LeilaGharani
2 жыл бұрын
Thank you so much 😀
@ooops372
2 жыл бұрын
EXPAND is also useful, because it is much shorter than =CHOOSE({1.2.3};...) (also returning a SPILL-Array).
@pwerda
2 жыл бұрын
Fantastic developments, but there still remains the challenge of having spill natured formulas to function within a table. Thanks Leila for the great explanation of underlying principles. Can't wait to use them.
@Shiffo
2 жыл бұрын
My favorite is also Textsplit. Using Left, Right, MID, LEN usually was a bit tricky to write. This saves a lot of complexity.
@jasonbb2010
2 жыл бұрын
So the text split function cannot split single word like only first 3 digs?
@Shiffo
2 жыл бұрын
@@jasonbb2010 i think you will need to wrap LEFT(,3) into text split.
@Bill_Woo
2 жыл бұрын
You are once again awesome. What a great site this is, and as a pro I have spent an enormous amount of time on webpages for Excel. And had you not published this, I would not have learned this - because other informational sources have too much *unimportant* info. The thing about this channel's videos is that IT SHOWS ONLY USEFUL AND PRACTICAL INFORMATION. And very, very well explained, simply enough to not leave me confused, but rapidly and efficiently delivered.
@ianbennett148
2 жыл бұрын
Are these new functions generally available yet? I am on the O365 "Preview" channel, but still don't seem to have them 😞
@aemero7477
2 жыл бұрын
All are amazing! I would say the TOROW AND TOCOLUMN functions are what I was looking for recently. Thank you so much!
@indigo.s
2 жыл бұрын
I am sorry, LEN + LEFT, it was beautiful while it lasted... But all things need to end.
@AzulonKaiba
2 жыл бұрын
I love this new functions. They behave like many properties with a Pandas dataframe in Python. In others words an Excel user will get use to Python easier.
@LeilaGharani
2 жыл бұрын
👍
@AzulonKaiba
2 жыл бұрын
@@LeeMbarrett Something I would want to see, it's the integration of Regex without VBA that's a powerful feature of Google sheets.
@muratmurat9982
2 жыл бұрын
Thank you very much. It will be useful to us. How can we get this update to our desktop excel because I can't get it
@matthiasheuer
2 жыл бұрын
Perfectly explained, Leila Gharani simply has it down, I always enjoy watching her videos.
@spoondi1
10 ай бұрын
textsplit is a very good one which I was looking out for a long time to replace many other formulas.
@omotossso
2 жыл бұрын
Looks like we are having an SQL class. Thanks for the tips, I am updating my Microsoft already... I love this and you got much of my respect Leila Gharani ❤❤❤❤ I love the TextSplit, Expand, are so dope, I have used similar functions onTextBefore and TextAfter are in PQuerry before. Nonetheless, having them in Excel is so much cool RN..... WOOOOW
@MarcioTubini
2 жыл бұрын
Hi. How can I translate the functions to another language!? Ex. Portuguese.
@YouGotPropofol
2 жыл бұрын
I wish excel would adopt the Mac numbers style of having a giant unlimited blank canvas on which you can create separate sheets. It’s much better than having tabbed sheets (which you can also do on Mac numbers).
@Yassine3333222222
2 жыл бұрын
I'm waiting for a function that converts text into formula, and another one that let me applies the function many times consequetively in the same cell
@sachinrv1
Жыл бұрын
These functions are so simple to use. No text to column, no transpose, no offset. This is more than one can expect. Time for everyone to switch to Office 365. Thanks Leila :)
@andrewcharlesmoss
2 жыл бұрын
This is awesome! More functions that will speed up our workflows. I am especially excited about TOCOL, which is Excel’s answer to Google Sheets’ FLATTEN!
@SL-og1qf
Жыл бұрын
Thank you so much, you’ve turned my tedious job into something I enjoy. It’s so insane that we have all these people in data/admin jobs that are never trained to use it to its full potential.
@henrycokoli9854
2 жыл бұрын
The choosecols and chooserows are goonna be popular indeed
@missiondec2163
2 жыл бұрын
All functions are absolutely fabulous ma'am. Many people still confuse about simple functions like VLOOKUP, SUMPRODUCT. My question is will people try to learn to use them? I don't think so. What is your opinion on this?? 😅
@rajeshvarmaangani4652
2 жыл бұрын
Does excel 2016supports these functions?
@LeilaGharani
2 жыл бұрын
No, only Office 365.
@mozgus79ify
2 жыл бұрын
Wow 😍. I think CHOOSECOLS will be my favourite.
@SpotlightImpact
Жыл бұрын
Love TOCOL!! Have already used it a few times!
@SolomonKinyanjui_sk
2 жыл бұрын
I like the formulas. This is amazing and Excel users and fans will have an easy time.
@AbhaySingh-vc2fk
2 жыл бұрын
Wow, everyone was wonderful! I have been doing this with long long formula.... My heart goes to say THANKS TEAM EXCEL only after *Thank You Excel Queen Leila* !!!!
@ppppaz6023
2 жыл бұрын
JUST WHY IT WAS RELEASED NOW?!! could have made my work all long time ago so productive ahhaha
@zak_9351
2 жыл бұрын
Wow, thanks for sharing/explaining these new functions. I'm particularly excited about VSTACK/HSTACK as often I'm dealing with users who like to split their data across multiple worksheets and this could help to bring it all together much quicker
@nayhem
2 жыл бұрын
Text to Columns: "I wanna be a formula!" I also seem to be coming across more table-like external data that boils down to a single column, and WRAPROWS definitely seems easier than wrangling the data any other way.
@JesseHardesty
2 жыл бұрын
I created a very complex dashboard in Excel to use for my job as a Training Supervisor, tracking training schedules, tracking documents, staff lists, a matrix and so on. This will eliminate so many of the confusing formulas I had to come up with and make it easier to add/remove people from certain parts when staff changes.
@RonDoh202
2 жыл бұрын
WOW! - in a lot of our reports the emphasis in on text, names, organisation etc., top choice TEXTSPLIT, but also CHOOSECOLS - amazing - Liela does it again! Thanks Leila
@Raph0ne
Жыл бұрын
Tip: in TEXTAFTER (BEFORE) you can use -1 or -2 to start from counting from Right to left
@owenrogers2316
2 жыл бұрын
VSTACK and TEXTSPLIT! will definitely be using these...when IT eventually deploys it...
@vida1719
2 жыл бұрын
Really great addition of new functions. For me Choosecolums and Splittext will be useful
@KarimKadiriMOTIVATOR
2 жыл бұрын
Hi. Is there a function to climb down to the bottom of our page (last utilized line)? And then back up? Thanks in advance
@davidtesta5793
2 жыл бұрын
LOVE, LOVE, LOVE your Excel training videos! Thank you for doing them, and for the easy explanations on how to use the functions. It's been 3 months since this video was made. Still waiting for the new functions in Office 365. Do you have any idea when these functions will be released to the public?
@gates1978
2 жыл бұрын
Could you please tell us which version of office 365 you have. I can't find all these functions on mine. Thanks
@LeilaGharani
2 жыл бұрын
It's the beta version for Office Insiders. You can get it for free if you have Office 365. But I had to de-install and re-install multiple times until I was in the 50% of beta users that got it.
@gates1978
2 жыл бұрын
@@LeilaGharani thank you so much. I will try to install it @hone. But unfortunately, we couldn't do it @work.
@trobi
2 жыл бұрын
I'm using Version 2202 Build 16.0.14931.20128 and can't see these formulas?
@mattschoular8844
2 жыл бұрын
Thanks Leila. It seems MS has taken many key features and options from Power Query and Pivot Tables and converted them into dynamic array functions. I can see many use cases for the in the future. Much appreciated...
@jawadahmadehssan6251
2 жыл бұрын
Thank you Liela, really useful and can't wait to start using them.
@ppst817
2 жыл бұрын
Actually all of them
@alexmercer3001
2 жыл бұрын
I have two Columns, The first row in column A has 5-10 paragraphs of text. First row in column B has some data separated by commas. I wanted to merge these two data in the columns into a new column. I want to Merge the data from the second column into the first column data after every newline character. And the data in the second column are separated by newline characters. How to do this using formulas or VBA scripts? I tried this, but am getting Invalid Name Error, =TEXTJOIN(CHAR(10),,TOCOL(VSTACK(TEXTSPLIT(A1,CHAR(10)),TEXTSPLIT(B1,CHAR(10))),3,1)) Am using MS Excel 2021.
@erikguzik8204
2 жыл бұрын
Agree, text split is a great new function, so many uses.!! but so far for me VSTACK... this can do the work of power query to some extent.... =VStack(Filter(Sheet1!A1:F30,F1:F30>1000),Filter(Sheet2!A1:F30,F1:F30>1000)) combines my 2 tables for all values in Column F > 1000 into one table ... can change to Tables instead of Ranges, so it will update when data is added. MY VOTE IS FOR ---- VSTACK !!!
@trebushett2079
2 жыл бұрын
And excel still doesn't have the easy macro language of Lotus 123 of 35 years ago - wonderful progress. We're not all expert visual basic experts. NOT IMPRESSED.
@kamalam29
2 жыл бұрын
Brilliant functions! though, been waiting for these not recently but for many years because these formulas are key functions for reporting automations!!! Report automations/Data Analysis would become so much easy with this. Leila Gharani as usual, brilliant presentation as well. I have had replicated some of these functions via UDFs (VBA) in past, so, I know the pain and relief after seeing these functions.
@Daenoril
2 жыл бұрын
Those functions are awesome! Favorites should be VSTACK and TEXTSPLIT
@rickgilbrt
Жыл бұрын
I work with delimited multi-part identifiers all the time where I need a part of the identifier for sorting and grouping. TEXTBEFORE() and TEXTAFTER() have eliminated all those complicated MID()-plus-FIND() formulas I used to write. Yayyy!
@shahbazraza8605
2 ай бұрын
Such an insightful video, My favourite formulas are Text split, tocol, torow and Vstake
@ramverma2751
2 жыл бұрын
How to extract multiple numbers from a text string (para) in a cell..... Like "ram is 900786 everywhere 800765 and shyam is 600873 everywhere" result required = "900786, 800765, 600873"
@FarshidMeidani
2 жыл бұрын
واقعیت اینگونه نیست و کسی منتظر چنین آپدیت هایی نبوده است. بزرگترین و مهم ترین درخواست کاربران اکسل اضافه کردن / جایگزین کردن زبان برنامه نویسی پایتون بوده است. گمان می کنم که تیم اکسل مایکروسافت با این آپدیت های نچندان مهم و یا آپدیت های مهمی مانند لامبدا سعی دارند که به نوعی متخصصین اکسل را وادار به استفاده از این توابع و این سبک پیچیده فرمول نویسی کنند. از طرف دیگر همانطور که خود شما به درستی نوشتید این فرمولها پیچیده و حتی بغرنج هستند و توجه شما و بقیه متخصصین اکسل را به پایتون زن جلب می کنیم که می گوید: Simple is better than complex. Complex is better than complicated. Flat is better than nested. Sparse is better than dense. Readability counts. Special cases aren't special enough to break the rules. و متاسفانه این سبک فرمول نویسی و این توابع کاملا برخلاف این اصول هستند . امیدوارم شما و بقیه کسانی که به تیم مایکروسافت دسترسی مستقیم دارید با نگاه منتقدانه ای به این توابع نگاه کنید و امیدوارم که تیم اکسل مایکروسافت زبان پایتون را به جای این آپدیت ها به اکسل اضافه کند. همچنین توصیه می کنیم که اگر نیازهای کسی و یا سازمانی به این اندازه پیچیده است به جای اکسل از پایتون استفاده کند.
@j.etl.h4362
Жыл бұрын
Leila, your videos have become a reference in our company. Thank you for your brilliant work.
@Rawat1108
2 жыл бұрын
Is it possible. =SUM(H2:H(2+COUNTVISIBLE(H2:H8))), It will look like =SUM(H2:H9), If we count from H2 to H8 it will be 7+2=9. If yes the n how and If not then there is another possible way for this.
@shadeburst
2 жыл бұрын
We've been waiting thirty years for SELECT. How much longer? FoxPro for DOS 2.6 back in 1992 or something had a fully functioning SELECT. When that is implemented, Excel can start calling itself a database manager. TAKE is cool. I've been writing formulas to show only a limited number of rows.
@daveatkinson1139
2 жыл бұрын
CHOOSECOLS is going to replace a ridiculously overcomplicated CSE INDEX, MATCH, MIN to grab all rows from a sheet that meet a criteria. Let's hope it's efficient.
@C_A_S_Excel
2 жыл бұрын
Hello Leila, I am excited too but as an office 365 user, I can not find that function yet. please tell me how could I use that function.
@LeilaGharani
2 жыл бұрын
You need to join Office Insider beta channel.
@C_A_S_Excel
2 жыл бұрын
@@LeilaGharani thanks, I installed the office insider channel but I can't find it yet.
@suyashdansena3249
2 жыл бұрын
Are these functions only available in the "Office 365" package or it's also available in "Office - Home and Student 20XX" versions? Please help...
@natemoss2026
2 жыл бұрын
Looks like a lot of functionality in Power Query is finding its way over to functions. Very cool
@Galileo2pi
7 ай бұрын
One more time, you're the best. Thanks so much, Leila. Do you remember the song "Nothing Compares to You" by Sinéad O'Connor? Don't get me wrong, but you're the best in Microsoft Excel.
@brandoncrawford1036
2 жыл бұрын
All right looking for information on using a pull-down. I'm wonder if it's possible to use the pull-down to pull the information I need from a group above . Listed below I have product on the left, time to produce, product 1 and product 2 to make the main Product. At the bottom will go with the shatter it's a pull-down of the hash,wax,clear, shatter. Trying to make it pull the information from the shatter row straight down. But I do have a twist. To the left of the pull downs I have a second pull-down (1-10) this is Production slots. So when I set the # of slots and pick my product is there a way to have the Total Time, Total Cuts, total P1 & P2 calculated out automatically so I know what I need with a few clicks and how much time I need before it's finished. Otherwise id have to make a table for each product. And that's actually a total of 20 tables. Just wondering if there an easier way using the pull-down and a formula in each time, cuts, P1& P2. Anything will be helpful. Oh I forgot to mention. Not exactly using Excel. It's WPS Mobile. But still if there's a way I can always add the file to a PC and get it to work. Thanks Hash 45 4 3 8 Wax 60 4 3 10 Clear Concentrate 90 4 3 12 Shatter 150 4 3 15 Product Total Time Total Cut's Total P1 Total P2 Cannaflour 0 Brownie TRUE BH Oil 120 Shatter
@jasonipfatsiong2062
2 жыл бұрын
FAVOURITE…VSTACK…thanks update Leila..take care
@abbottkatz8830
2 жыл бұрын
Can TEXTSPLIT call upon multiple delimiters simultaneously, as with Google Sheets' SPLIT?
@leksdic
2 жыл бұрын
OMG. textbefore and textafter are gonna be of so much help. in my company product descriptions are like this "000000-description". so far after haveing downloaded the data from the BI tool i have to transform it before i send it away. So far i would do =left(A1,6) most of the time, but some old product codes are 5 digits, so i'd have to use search too. For the description i have to do =right(A1,len(A1)-search(A1;"-")). Now i can use just 2 formulas straight up. This is just too good.
@RickMeister64
2 жыл бұрын
I have O365 (Excel Version 2204 Build 16.0.15128.20128) and still don't have these new features. Are they not released yet?
@Sasha_5M
2 жыл бұрын
I am using Office 365 Version 2204 (Build 15109.20000) and also have joined office insider program beta channel....but still i am not able to see these formulas in it....could you please help ?
@anasfrh
2 жыл бұрын
This amazing!! Looks like Excel is making it easier and easier to manipulate "data frames" and perform stacking, unstacking, pivoting etc. transformations.
@chefbennyj
2 жыл бұрын
Isn't the backend of excel using visual basic? Enable developer options, and then you can write visual basic script. Create your own functions and methods.
@daveandanneatkinson1507
Жыл бұрын
Hi Leila, do you have any idea when/if these functions will be available outside of BETA? Specifically interested in CHOOSEROWS and CHOOSECOLS. Thank you. I mentioned your name and apparently you have many fans inside our organization (Loblaw Canada). Do you do tailored training for organizations? I'd love to see if we could have you do a Loblaw specific session, even if only a short one hour video. Thank you for your response.
@fvheel
2 жыл бұрын
Hi Leila I am looking for a way to copy a celvalue to a different cel as text without a function in the target cel. Example: C1: "=C:\Date\" [Path] D1: "=Data" [Filename] A1: "=Date()" [Current Date] B1: "=Time() [Current Time] E1: "=Filenumer" [Indexnumer of file] A3: "=A1 & B1 & " - " & C1 & D1 & " - "E1 & ".XLSX" So A3 puts all values of row 1 in one filename including path, filename, date, time, number & the extention. Now i want to save the excel-file using this field (witch has the correct filename). When i try to save the file using CTRL+C (copy cel) and hit F12 (save file) and paste it in the Filename field with CTRL+V then nothing is pased because the selection is no more. The dots around the selected field disapears when you hit F12. When i try to copy the value in cel A3 with F2 then i can only copy the formula in that cel, not the value. So i need the value that is in A3 not as a formula but as a value in A3 or a different cel so i can copy the value. Do you know a function that can do this: A4: Copy the value of A3 to cel A5 So i must be able to edit cel A5 I can not use VBA else it would be very easy. Microsoft does forbid macros. Thank you
@bigg6153
2 жыл бұрын
Hi Leila, my excel version is Version 2202 (Build 14931.20132), but the "textsplit" function is not available. Is there anything we need to do to make it appear in our Excel?
@averaguilar
2 жыл бұрын
Leila why can't I make it work? I have office 365 annual subscription, and yet I cannot find the TOCOL and TOROW functions for example. Besides my subscription is in Latin America, so maybe they are called differently, OR, they have not been depoyed in LA?
@eddieamorgan
2 жыл бұрын
Happy Nowruz. I know it's early, but I was at a Nowruz party yesterday. I was asked if I knew any Persian women I respected and liked. You and Christiane Amanpour were the first women that jumped into my mind. PS. I went to the American International School of Mallorca graduated in 1988. 40% of the students there were from Iran, many of them refugees. So, you're younger than I am, and remind me of those snotty little Iranian girls that kid ass in math classes ;) Once again, thank you for your excel spreadsheets instructions. They always help me out. Thank you for what you do. You are the best.
@stevenandry5122
2 жыл бұрын
For some unknown reason, I don't have that function (TEXTSPLIT) on my Excel. I'm running the lastest version of Microsoft Office. I pay a monthly fee with Microsoft for all office products.
@charlie5116
Жыл бұрын
For those who don't have Office 365, you can find quite some these functions in G-Sheets. That's also the reason why now I choose G-Sheets over Excel. For me, Excel is more like a versatile tool box, and in contrast G-Sheets is like a handy Swiss Army knife.
@martinhoude3518
2 жыл бұрын
Well, since I JUST got the Lambda function, I think it will take a while before the Mac version gets these. I have to say, my favorite might well be the TOROW & TOCOL functions. The TEXTSPLIT is also nice, but it's much easier to replace with the older functions and the LEN function. In contrast, the TOROW and TOCOL replace a lot of copy-pasting that is done before any formulas can be applied. The other functions are also nice; I just have to face these situations less often.
@salemnj1
2 жыл бұрын
We're stuck with Office Pro Plus 2016 where I work. Don't have much hope these functions will come into my world any time soon. :(
@Raj13Prince
2 жыл бұрын
I have one doubt? Can all these formulas work in normal excel or is there any particular version or installation for these?
@cavyommmehta
2 жыл бұрын
Thank you Leila. The video is very much informative. I was waiting for new excel formulas and Your Explanation. 👍✔️💯
@stockshow7363
2 жыл бұрын
Need voice based commands. I want to give a voice command stating the if headerX equals 40, and if header Y. is less than ccc or headeZ is greater than equal to hhh, the give me the output.....this looks to be silly but that day is also possibility...thank you Leila for your wonderful teaching
@JasonHelbert
2 жыл бұрын
TOCOL is probably what I will use the most to convert text to columns into one column. With the TEXTSPLIT, I can probably put together something that I can apply in one step. I've been subscribed ever since the XLOOKUP video, which I use daily and would nor have otherwise known about.
@anaawayan-lat3932
2 жыл бұрын
What if I want to separate names into two columns? Example: Mary Rose De Guzman I want: column 1:Mary Rose column 2: De Guzman How do I separate the names? Help please thank you
@cruzinsweetsntreats
2 жыл бұрын
Hopefully 1 day, but vstack shows up with the "#name" error when viewing on Android Excel. Though functional on desktop. I even joined Beta for Excel on Android, same result. Though still much faster response than doing a refresh on a set of linked tables via Power Query.
@hrleif8994
2 жыл бұрын
Yes, Textsplit is it.! But think i still need Right. The names example. I want column with 1.Names, 2.empty or middlenames, and then 3.last Names. Found your channel a few weeks ago. Love Excel, and now this channel.
@cruzinsweetsntreats
2 жыл бұрын
As of Wednesday, September 27, 2022: vstack and 13 other text and array functions *are now* available for Excel Android (as that's what I have). I'm signed up for Insiders Beta Channel, currently on Android version 16.x.x, so it *may not be* available for the general public as of yet. The results are dynamically loaded, for faster results on the go. Compared to the extra time and hassle of tables set up in Power Query, which then require a desktop version to refresh the data, save the spreadsheet, and then reopen the spreadsheet on Android.
@vsenikizanety
2 жыл бұрын
Too bad my company not getting updates for excel... We still don't have xlookup... :(
Пікірлер: 1 М.