Комментарии:
Thanks ❤
ОтветитьYeah it is annoying that it automatically split cells after using it once. Thanks for this video. Very useful!👍
ОтветитьThank you for your explanation
ОтветитьThank You🙏🏽
ОтветитьGreat thanks
ОтветитьI found this to be very helpful. Thanks for sharing
ОтветитьThanks, you are a lifesaver. I my case my data was comma delimited, but excel started splitting all my formulas I copied, by comma as well which is extra annoying. Restarting fixed it.
ОтветитьLife Saver!!
ОтветитьThank you Mr.Excel ...
ОтветитьThank you! Great tip! very annoying XL behavior!
ОтветитьThanks again for the tip. I always end up restarting my computer, wasting so much time. But now I know the simple fix for this.
ОтветитьBrilliant! Thank you for that Mr Excell!
ОтветитьHello,
How can i remove stop words in Excel?
i have a large number of words, and i want to remove stop words from all to analyze correctly
How can i do it, please?
thanks
1. Thanks so much
2. Unclick Tab, and it goes away all together
3. Having found out the logic of what is going on , I was able to use this feature to speed up my work. so, yeah!
Awesome! This is a PERFECT resource - I'll definitely check you out when I need help on strange stuff, definitely not an easy answer to find otherwise. And yes, it would really be nice if there were a flag/option to manage the auto-apply feature.
ОтветитьI could kiss you right now!!
ОтветитьYou're a life saver!
Ответить@bjele123 It's two cells away!
ОтветитьAAAAAAAAARRRRRRRGGGGGHHHHHHHH It's not only from outside Excll, it's also from within. I used a text-to-column, then decided not to use it. I'm trying to move a date (Feb 6 2012) from one cell to another, and the frikin date gets parsed too! YUK, this has to be the stupidest idea Gates has ever allowed in this software. Parsing should not stay on. It should be a "on request" command only, unless the user specifically states to leave it activated. And in this case, closing Excel does not work.
Ответить