MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_axZj8Irt5W8 200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content
@MrBradWilliams
4 жыл бұрын
Long-time viewer, first-time commenter. 🤣 Nice manner of describing the formulas so they're simple to understand and adapt. I can tell you're an old school Excel user from before the Ribbon. Your comments and observations about the quickest or easiest way to remember how to use shortcuts sound like they're coming straight out of my internal dialogue. Not having easy to use shortcuts in other applications drives me nuts, and I've started using AutoHotkey to create my own. Even in Excel, sometimes it's difficult to quickly format the font color or fill of a cell (without Visual Basic), so I have to write macros. Sometimes easier with AutoHotkey than with the internal Macro recorder / VB editor.
@TeachExcel
4 жыл бұрын
hahaha thanks for the comment!) i'm glad you like how I talk about the formulas, I never want anyone to feel left behind, just be careful watching the 30 minute+ ones as those might make a regular user sleep hahah. And, yea, shortcuts, it is one of those things that once you get started with them, you start to wonder how much of your life you lost before using them!!! AutoHotkey is a godsend! I downloaded it last year and now my only worry is getting on a computer that doesn't have it - this kind of software should be standard on every copy of windows in my opinion!
@DesignReady.
2 жыл бұрын
Tell me how to add
@vannakr25
Жыл бұрын
I have Excel 2016 (MS Professional Plus 2016) - the TRIM function doesn't work on mine. I have a word in Cell A1 ===>"Nalleem, Sajjida " with several spaces after the word Sajida - it won' trim; i'm getting the same len=30. I even copied the word onto your Excel formula - still no luck
@waltermakuzander5248
4 жыл бұрын
I find this very helpful especially in countif formula :)
@gregwmanning
4 жыл бұрын
Great video. I have always used Ctrl H. Trim function looks handy the substitute function looks invaluable. Thanks
@TeachExcel
4 жыл бұрын
Honestly, that is a really good way to do it without much fuss. Props to you for remembering the Ctrl + H shortcut, or maybe I am the only one who can never ever remember it haha
@ramu992
7 ай бұрын
I dint even watch he complete video, I saw TRIM Function in your comment and tried it, it's exactly what i needed
@Isaiasmtzzz
Жыл бұрын
Can you do this with the web version? It’s not really working on the web version for me.
@bbbb6052
7 ай бұрын
How to remove the space in front of the words. Example: “ 18”
@Funway20
2 жыл бұрын
I clicked on Description link but no excel file get download but take me in to different page but I did not get the file
@IvanCortinas_ES
4 жыл бұрын
A very complete tutorial. Thank you!!!
@TeachExcel
4 жыл бұрын
You are very welcome! I'm glad you think so! :)
@ragavendran66
4 жыл бұрын
Thanks for removing spaces video. Very useful to me. Please make videos these kind of tricks. So that I would expert in excel
@TeachExcel
4 жыл бұрын
I'm very glad that you like the video! Give me some ideas about what you would like to learn! I love making videos like this but they don't seem to be as popular as some more basic single function oriented videos, so I'm open to suggestions)
@independentbaptist3561
3 жыл бұрын
None of this worked. I have 7 spaces before a number.
@vishalbhati912
3 жыл бұрын
I don't know about len formula which i found in ur video. Thanku very useful formula for me
@TeachExcel
3 жыл бұрын
I'm glad I could introduce you to it! Try and remember this one because it has many nice uses, especially when things get complex!
@gamingdude3965
2 жыл бұрын
how to fully remove space in regular text folder
@Aaratikamtekar
3 жыл бұрын
I want formula how to give space between these words for e.g. johnrosemark, which formula is using to give space for these words, please reply
@shiwaniagrawal6610
3 жыл бұрын
Thanks you meri office mi koi help nahi kar raha tha thank you abhi mai kaam he kar rahi hu thank you
@wayneedmondson1065
4 жыл бұрын
Great video.. lots of good ideas in there. Thanks for sharing these tips and tricks. Thumbs up!!
@TeachExcel
4 жыл бұрын
Thanks a lot Wayne! By the way, the new Excel 365 formulas are slated to start up in a week or two, so hopefully, those will be interesting too)
@New_moon305
3 жыл бұрын
Icing9 7799 666 how can you remove the spaces in above format. Could you please make a video.
@jinzakk23
2 жыл бұрын
i wanted to like this video but i didnt, lets keep it at that number
@louisebastard2091
2 жыл бұрын
Thank you you have just saved me hours of work keep video great I had 196 rows to take . out and spaces you really saved me time again thank you
@iqraali961
3 жыл бұрын
Hello Sir, I want to remove the sapce at the end of emails data. But when I type =trimA( In the second coloum it shows **Name?** Instead of email address. Please let me know how to fix it.
@Itisme177
4 жыл бұрын
Thanks you for upload it, it’s very helpful to me. Now please upload for changes of date format from different formats.
@annetterussell9871
3 жыл бұрын
Hello can you tell me why the trim function will not copy down? Instead it reads the same word down the column. Thank you
@filmexfilmex
5 ай бұрын
Thank for this
@SubbuTube
Жыл бұрын
Very helpful. explained all types of spaces deletion.
@einfjordbreen2925
3 жыл бұрын
Nope...Tried both and they don't work for my issue,.. Try this: (31.25 ) [space after 5] and use Trim and or Substitute...Neither work as they are both 6 charters long after...and still TXT ...thus still cant use in math's functions.
@TeachExcel
3 жыл бұрын
Try this guy (My Char 160 Tutorial) : kzitem.info/news/bejne/ua2DtG18i3ZkhKA I think char 160 might be your issue.
@deepakpatwa7157
3 жыл бұрын
Can we fixed the second word of the name at specific intervals of that cell of that column like name and surname of student's
@kgeehomie6091
3 жыл бұрын
Super analytical and helpful video.. Bravo!!!!
@xpon7833
4 жыл бұрын
thanks for the shortcut. i always use ctrl +v, then ctrl v again LOL
@TeachExcel
4 жыл бұрын
To paste values? I am a little confused, though I haven't had my second coffee for the morning haha.
@xpon7833
4 жыл бұрын
@@TeachExcel yes, it only work with newer version since office 2003 or 2010
@yacinegcm1205
2 жыл бұрын
Thank you
@NasirUddin-cz6ym
2 жыл бұрын
Thanks
@TanzilHudaJnU
3 жыл бұрын
Just an amazing and the best video about extra space.
@deepakpatwa7157
3 жыл бұрын
Can we fixed the second word of the name at specific intervals of that cell
@lonniemullen8201
3 жыл бұрын
Very helpful explanation. Thanks!
@RahulKumar-ly6ly
3 жыл бұрын
Thanks sir very helpful video
@kamingmgasmallyoutuber5157
2 жыл бұрын
I LOVE YOU. YOU ARE SMART
@SujeshKRamu
3 жыл бұрын
Thank you
@TeachExcel
3 жыл бұрын
You are very welcome Sujesh :)
@Mythilisathishkumar
Жыл бұрын
Thanks a lot for your help 🙏
@djamelbek7506
2 жыл бұрын
thank you very much
@PradeepKumar-ng5oy
2 жыл бұрын
Great! Thanks a lot 🔥
@RajeshChandran81
2 жыл бұрын
That was awesome. Thanks
@anilshrestha4125
2 жыл бұрын
Thank you 💖💖💖
@RohitKumar-cc7zi
2 жыл бұрын
Good bro 🤜🤜
@spunjbom
4 жыл бұрын
It's all well and good until a wild char(160) appears.
@TeachExcel
4 жыл бұрын
I heard they make firing squads legal now for this situation! hah
@mdcs1992
4 жыл бұрын
I had a heart attack a year ago and have been too ill to work. Excel is my bread and butter and your videos help to keep my skills current. Also, it's always best to have several methods that achieve the same or similar results. Thank you for doing what you do.
@TeachExcel
4 жыл бұрын
You are very welcome! And I am very glad to hear that you are keeping yourself busy and alert! I hope that you will be better soon and I am very happy that I am able to help!!! If you ever have any suggestions on things you'd like to see, feel free to post a comment any time under my most recent video so I can notice and give it a reply! (sometimes I don't notice comments on older videos) Oh and if you want some fun in Excel, check out my Christmas Tree worksheet, that one always gave me a chuckle - maybe an update to a Pumpkin version is in order haha. I hope you have a great and healthy week!!!!
@mouniqua
3 жыл бұрын
Wow! Thanks a ton. I always struggled with this space pre ans post issues. This gives me a lot of relief. Thanks alot. You are the best!
@toxiqrox
4 жыл бұрын
That is really useful you are teaching me more than you will ever know. I am also trying to learn SQL and your explanation between the two talking marks now makes more sense.
@TeachExcel
4 жыл бұрын
I am very happy that I can help you Kathy :)
@buckmanrecruiting
3 жыл бұрын
Great stuff!
@Myclassicalrecording
4 жыл бұрын
Can you create xlookup with vba in earlier versions of excel?
@TeachExcel
4 жыл бұрын
Not directly, but you can make formulas that do a similar thing and I have 2 tutorials on this topic that you might like: kzitem.info/news/bejne/23im0YiKsmSHnHY kzitem.info/news/bejne/23im0YiKsmSHnHY
@TeachExcel
4 жыл бұрын
Also i will have an xlookup tutorial coming out soonish)
@Myclassicalrecording
4 жыл бұрын
You're going to create an xlookup vba video? I understand how it works, I was just trying to create my own formula in excel 2013 if possible. I'll just use the formulas you provided
@TeachExcel
4 жыл бұрын
Yea it will be released soon, but look to the other links I gave you and you will see how to do it for Excel 2013
@tommagney5959
2 жыл бұрын
Great tutorial! unfortunately, I've not been able to make this work on a dataset I copied and pasted from the Web. Apparently there are other things that LOOK like spaces that TRIM, SUBSTITUTE or Replace just can't see. But I'm gonna use these tricks! Thanks!
Пікірлер: 68