Excel - Disable Auto Text to Columns: Stop Excel from Breaking Apart Your Data! - Episode 1383

Excel - Disable Auto Text to Columns: Stop Excel from Breaking Apart Your Data! - Episode 1383

MrExcel.com

13 лет назад

17,847 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@anujk7086
@anujk7086 - 20.09.2022 09:21

Thanks ❤

Ответить
@jeromeduran7419
@jeromeduran7419 - 30.04.2022 12:55

Yeah it is annoying that it automatically split cells after using it once. Thanks for this video. Very useful!👍

Ответить
@sundarnatarajan8305
@sundarnatarajan8305 - 07.02.2022 20:14

Thank you for your explanation

Ответить
@silvan5851
@silvan5851 - 14.06.2021 16:03

Thank You🙏🏽

Ответить
@deepaksasidharan8
@deepaksasidharan8 - 17.08.2020 17:32

Great thanks

Ответить
@amirmuhammad5431
@amirmuhammad5431 - 05.06.2020 11:51

I found this to be very helpful. Thanks for sharing

Ответить
@michaelelkin9542
@michaelelkin9542 - 21.04.2020 17:06

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.

Ответить
@abcd1to
@abcd1to - 25.09.2019 13:45

Life Saver!!

Ответить
@harissetyawan3833
@harissetyawan3833 - 27.04.2019 01:57

Thank you Mr.Excel ...

Ответить
@elizabethdyment101
@elizabethdyment101 - 21.12.2018 10:39

Thank you! Great tip! very annoying XL behavior!

Ответить
@aquayum72
@aquayum72 - 07.11.2018 20:21

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.

Ответить
@lukaszpatryn5686
@lukaszpatryn5686 - 14.09.2018 17:20

Brilliant! Thank you for that Mr Excell!

Ответить
@mohamedomarismail4954
@mohamedomarismail4954 - 09.12.2016 22:14

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

Ответить
@jacobvick2544
@jacobvick2544 - 10.12.2014 01:54

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!

Ответить
@russellpark
@russellpark - 14.02.2014 22:23

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.

Ответить
@harleemorgan
@harleemorgan - 04.06.2012 20:07

I could kiss you right now!!

Ответить
@Ruggerwoman
@Ruggerwoman - 05.04.2012 02:40

You're a life saver!

Ответить
@tallard666
@tallard666 - 18.03.2012 08:13

@bjele123 It's two cells away!

Ответить
@tallard666
@tallard666 - 07.03.2012 15:19

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.

Ответить