3 NEW Excel Text Functions I wish I had years ago! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 9
Wayne
Hi Mynda. Thanks for the great array constant -- tricks! Been waiting a long time for better text functions. Finally, can retire FILTERXML/SUBSTITUTE combination to split text. And with the optional arguments, the new functions are so much more flexible and useful! Thanks for demonstrating. Thumbs up!!
reply
Hi Mynda. Thanks for the great array constant -- tricks! Been waiting a long time for better text functions. Finally, can retire FILTERXML/SUBSTITUTE combination to split text. And with the optional arguments, the new functions are so much more flexible and useful! Thanks for demonstrating. Thumbs up!!
reply
DRSteele
Excellent summary, Mynda. Awesome new functions. Hot tip: if you want to avoid having to press up-arrow or hunt with the mouse EVERY time you invoke a formula, you can change the setting in File - Options - Advanced - Editing options and remove the checkmark for 'After pressing Enter'.
reply
Excellent summary, Mynda. Awesome new functions. Hot tip: if you want to avoid having to press up-arrow or hunt with the mouse EVERY time you invoke a formula, you can change the setting in File - Options - Advanced - Editing options and remove the checkmark for 'After pressing Enter'.
reply
Vijay
Thank you Mynda for this introduction to the new super functions! Can't wait for these to be available generally, and know that we are already prepared for them through your video! Keep up the great work you are doing! --
reply
Thank you Mynda for this introduction to the new super functions! Can't wait for these to be available generally, and know that we are already prepared for them through your video! Keep up the great work you are doing! --
reply
Average
Is there a formula to split date/time?
I have been using right or left, but with the difference between 3/3/22 2:23 and 3/13/22 12:23 month over month.
Will text split work if it looks for a space?
reply
Is there a formula to split date/time?
I have been using right or left, but with the difference between 3/3/22 2:23 and 3/13/22 12:23 month over month.
Will text split work if it looks for a space?
reply
darryl
Hi Mynda!Great Tutorial, Really Exciting Times With All The New Functions Microsoft Have Introduced To Excel.Looking Forward To Trying Them Out When The Become Available...Thank You :)
reply
Hi Mynda!Great Tutorial, Really Exciting Times With All The New Functions Microsoft Have Introduced To Excel.Looking Forward To Trying Them Out When The Become Available...Thank You :)
reply
karunakar
Thank you Mynda foe this amazing trick.
I'm not able use those r the formulas in my excel and currently using MS excel version is 2019 in my system.
Kindly suggest...
reply
Thank you Mynda foe this amazing trick.
I'm not able use those r the formulas in my excel and currently using MS excel version is 2019 in my system.
Kindly suggest...
reply
Up4Excel
TEXTSPLIT is a fantastic new formula that will save so much time and effort for Excel users. Thanks for the in depth demonstrations Mynda -
reply
TEXTSPLIT is a fantastic new formula that will save so much time and effort for Excel users. Thanks for the in depth demonstrations Mynda -
reply
loukas
Thank you for the great videos...could I ask how you insert filters in your videos that are only visible when you click on the cell?
reply
Thank you for the great videos...could I ask how you insert filters in your videos that are only visible when you click on the cell?
reply
Ced
As usual great demonstration. On the side, what are the -+- and --- signs and the -1- and -2- on the left side of the spreadsheet?
reply
As usual great demonstration. On the side, what are the -+- and --- signs and the -1- and -2- on the left side of the spreadsheet?
reply
Add a review, comment
Other channel videos
