Using the Trim Function in Excel

  Рет қаралды 344,110

Technology for Teachers and Students

Technology for Teachers and Students

Күн бұрын

Пікірлер: 84
@nodnalneyugn8753
@nodnalneyugn8753 3 жыл бұрын
Disclaimer: I"m not him pretending to be someone else. I'm just a fan of this channel. Please donate to this channel. I've done so myself. Any amount will help support him and allow him to keep making more of these awesome Xcel videos. He spends a lot of time making these videos, and the practice Xcel spreadsheets. I've been binge watching these Xcel videos and learning a lot from them. I've learned so so much! Thank you, "Technology for Teachers and Students" :)
@OlgaOliver-Diaz
@OlgaOliver-Diaz 8 ай бұрын
I found the explanation so very easy to follow and straight to the point. Good speed too, not too fast and not too slow.
@maryannlim2295
@maryannlim2295 2 жыл бұрын
Awesome! Very beginner friendly way of teaching. So easy to understand. Thanks so much
@janebuckland737
@janebuckland737 8 ай бұрын
Excellent communication and instruction. No time filling just really useful productive information. Thank you
@adysyady5527
@adysyady5527 2 жыл бұрын
God you just saved me a lot of times to do my jobs. Thanks. Big thumbs-up for ur content!!
@FaysalEasyExcel
@FaysalEasyExcel 3 жыл бұрын
TRIM function removes spaces before and after text or numbers and keeps only single spaces in between words or texts. Thanks a lot. Great tutorial.
@demorelax6420
@demorelax6420 Жыл бұрын
OMG THANK YOU SO MUCH I DIDN'T KNOW I HAVE TO MAKE A NEW COLUMN TO APPLY THE FORMULA, THANK THANK THANK YOU
@Bravemusic737
@Bravemusic737 3 жыл бұрын
what i love is you provide materials for practice. thanks.
@joeytang3532
@joeytang3532 5 жыл бұрын
Your videos are awesome ! I’m in a binge watch session of all your Microsoft words and excel videos, and I’ll probably watch it more than once . Very helpful not just for teachers and students but working professionals too! Thank you so much for doing these videos :)
@kn0389
@kn0389 2 жыл бұрын
I was working on a CSV file in excel and I'm having problems with leading and trailing spaces. I don't want these spaces to be included in my Database. Luckily I found this tutorial; it saved me a ton of time 💙
@tihomirvokic5257
@tihomirvokic5257 Жыл бұрын
Thank You very very much Greetings from Croatia
@junjunmulleda5467
@junjunmulleda5467 3 жыл бұрын
Love the quick tips. Always easy to learn from your tutorials. Thanks!
@silviac.929
@silviac.929 2 жыл бұрын
This is GREAT. Thank you. Subscribed. Excellent explanation.
@aramschwartz4502
@aramschwartz4502 Жыл бұрын
Great Video!! Thank you!
@Suraj_Mehra0211
@Suraj_Mehra0211 4 жыл бұрын
That was an amazing and detailed explanation. Thank you for the video!
@saunderssm
@saunderssm 5 жыл бұрын
Great tip! Wish I had known this a while ago!
@rizalfatoni4075
@rizalfatoni4075 4 жыл бұрын
"so it removes those extra spaces", finally. Thanks a lot, this helps in saving my time!
@amirahervol9199
@amirahervol9199 11 ай бұрын
so easy to understand. Thanks!
@nw9497
@nw9497 10 ай бұрын
You're a good teacher
@adefabrisio8576
@adefabrisio8576 3 жыл бұрын
Great Tutorial - Thank you so much in 2021
@annieudoh1745
@annieudoh1745 Жыл бұрын
The best among all videos
@anasser
@anasser 4 жыл бұрын
I strongly appreciate your hardworking making these videos. I have learned a lot from you, seriously. I just have a question, is there a function that combines both (trim and proper) together?
@BobbyDazzler490
@BobbyDazzler490 5 жыл бұрын
Brilliant well showed and easy to follow
@SeemaSharma-lj3cf
@SeemaSharma-lj3cf 4 жыл бұрын
Thanks for sharing. Very helpful
@starfish258852
@starfish258852 2 жыл бұрын
Thank you very much.
@batoolfatima9218
@batoolfatima9218 4 жыл бұрын
Great video. Very clear explanation. 👍🏻
@mohammedalsahli1273
@mohammedalsahli1273 3 жыл бұрын
Thank you very much for this video.
@abdullahabdulwahabfarhanal8496
@abdullahabdulwahabfarhanal8496 2 жыл бұрын
Thank you so much👍
@dheerajdheeraj4429
@dheerajdheeraj4429 11 ай бұрын
Thanks for showing deleting uncleaned data (duplicate data)
@roopinderrandhawa3996
@roopinderrandhawa3996 2 жыл бұрын
Great to the point video !!!
@brunorivarolla
@brunorivarolla Жыл бұрын
Good content and clear
@Erifon22
@Erifon22 3 жыл бұрын
You are a life saver.
@thouhakheng168
@thouhakheng168 4 жыл бұрын
I love all your videos and also like all your videos😛😛😛
@lisamars86
@lisamars86 5 жыл бұрын
Uhh how did you get my DVD collection list!? Another great video, thanks alot for Posting!
@abdullahwaseem4321
@abdullahwaseem4321 4 жыл бұрын
Thanks, it was really comprehensive but useful 😘
@gabrielamarante1796
@gabrielamarante1796 3 жыл бұрын
Great video, thank you
@patb8985
@patb8985 3 жыл бұрын
Brilliant! Thank you very much.
@skip031890
@skip031890 Жыл бұрын
You can also just select the whole range of cells you want to affect in the formula and it will spill the results in the other cells automatically.
@Cris-hk4cn
@Cris-hk4cn 3 жыл бұрын
Thanks, easy to understand.
@Ateeq10
@Ateeq10 7 ай бұрын
thank you so much
@yapjialer7115
@yapjialer7115 3 жыл бұрын
great tutorial, detailed nad patience :)
@ruturajpatil914
@ruturajpatil914 2 жыл бұрын
USEFUL INFORMATION
@ouahibabela8986
@ouahibabela8986 2 жыл бұрын
Thanks a lot
@ashishgarggarg5379
@ashishgarggarg5379 2 жыл бұрын
how to apply trim function on whole sheet ?? if i have multiple column but i dont want to apply trim function on each column saperately how to do that?
@cindyhui6612
@cindyhui6612 4 жыл бұрын
Thank you for your video!
@realdanafields
@realdanafields 3 жыл бұрын
Thank you!!!!!!!
@bigteno4597
@bigteno4597 5 жыл бұрын
Brilliant stuff!!!
@jocyanjocyan6409
@jocyanjocyan6409 3 жыл бұрын
Great, Thanks a lot
@taylormckenzie8897
@taylormckenzie8897 4 жыл бұрын
Thank you.
@bhavinpatel225
@bhavinpatel225 4 жыл бұрын
Can we also use proper formula in this situation ?
@996_SakshiSingh_44
@996_SakshiSingh_44 4 жыл бұрын
Thank you
@slainiae
@slainiae Жыл бұрын
How does one trim a date&time column (e.g 01/09/2017 00:02:01)? Thank you.
@islamelabbady2752
@islamelabbady2752 3 жыл бұрын
awesome!
@newalzebary4301
@newalzebary4301 2 жыл бұрын
thanks
@parveenyadav4680
@parveenyadav4680 Жыл бұрын
when i use trim formula all my highlighted and coloured text becomes black is there any way to apply trim without loosing color
@melissacacnio8351
@melissacacnio8351 4 жыл бұрын
Do you have sample for numbers with spaces in between?
@lifewithshidit
@lifewithshidit 4 жыл бұрын
Awesome👍👍🙏🙏
@feljunpaquingan17
@feljunpaquingan17 2 жыл бұрын
Hi, May I ask how to add a Dash "-". example: AB087 becomes AB-087
@rajsuthar999
@rajsuthar999 2 жыл бұрын
How can the user be prevented from filling such data as in column A.
@philipgreenfield188
@philipgreenfield188 4 жыл бұрын
good vid but I need a function take the name only from a unc path I need a function to know to take the "John Smith" out of the path. and extract it out into a separate column
@HiRa-tq6xg
@HiRa-tq6xg 5 жыл бұрын
Thanks
@khaja7245
@khaja7245 2 жыл бұрын
thanks i tried this but it doesnt paste gives error message " to do this all merged cells need to be same size" how to fix that please
@daniely1203
@daniely1203 4 жыл бұрын
Just for info, there is a limitation. For example, if the original word is 'tri m', the changed word treats them as 2 words 'tri m' and do not change them to 'trim'.
@SIMRANKAUR-eg7nc
@SIMRANKAUR-eg7nc 4 жыл бұрын
U can do that also as per ur requirement actually. Press control H to get to find and replace. And there find "space" and replace that with nothing.
@SIMRANKAUR-eg7nc
@SIMRANKAUR-eg7nc 4 жыл бұрын
Search channel "off to office". You will find unbelievable methods of preparing raw data copy pasted from any web source or some pdf files.
@meagneschan2643
@meagneschan2643 Жыл бұрын
Can't fix the ending spaces in my excel, why?
@babarali8430
@babarali8430 3 жыл бұрын
sir i have name of product in two languages in the same cell, i want to keep only english name and romove other one. how i can do it. for example: "CHIKALAB Dragee ""Chocolate covered almonds"" 120g/ CHIKALAB Драже ""Миндаль в шоколаде"" 120 гр." i want remove after 120 g from the whole sheet
@swizlestick
@swizlestick 4 жыл бұрын
IS there a way to do this without creating a new column?
@SIMRANKAUR-eg7nc
@SIMRANKAUR-eg7nc 4 жыл бұрын
U have to apply formula somewhere. But that's not an issue u can either hide the original column or copy paste special (only value) on the same old data.
@SIMRANKAUR-eg7nc
@SIMRANKAUR-eg7nc 4 жыл бұрын
Search channel "off to office". You will find unbelievable methods of preparing raw data copy pasted from any web source or some pdf file.
@harshgautam5694
@harshgautam5694 3 жыл бұрын
It's not working .... Idk why .... My data still has space at the end of it ? Can you help with it ?
@khtoday2553
@khtoday2553 4 жыл бұрын
Hello can you show me how to link comment cell to other cell ?
@Dr_talbuaia
@Dr_talbuaia 5 жыл бұрын
please add pagemaker turtorial
@burak9857
@burak9857 4 жыл бұрын
I tried adding a couple of punctuation errors and tried it. I guess it only works for spacing :(
@arielsaballa8880
@arielsaballa8880 2 жыл бұрын
But first you have to make sure that the whole sheet is on General format coz if not. The formula won't read.
@Custerd1
@Custerd1 Жыл бұрын
I tried the tips in the video and it wouldn't work - this comment from you helped me. Thank you.
@ashishdaharwal4427
@ashishdaharwal4427 4 жыл бұрын
Paste special crtl+ alt + V simple
@GQElvie
@GQElvie 3 жыл бұрын
never addressed spaces after the last word, so v lookups do not work.
@mikegruber172
@mikegruber172 3 жыл бұрын
could just double click the autofill
@saiteka
@saiteka 6 ай бұрын
When single space is in between one name then it doesn't removing single space.
@stephendehart9777
@stephendehart9777 5 жыл бұрын
NO SOUND!
@LitoDaBurrito
@LitoDaBurrito 4 жыл бұрын
thankyou so much
@marinelamalceva9026
@marinelamalceva9026 5 жыл бұрын
Very helpful! Thanks!
Using Find and Replace and Wildcards in Excel
4:27
Technology for Teachers and Students
Рет қаралды 47 М.
Intermediate Excel Skills, Tips, and Tricks Tutorial
20:18
Technology for Teachers and Students
Рет қаралды 6 МЛН
MY HEIGHT vs MrBEAST CREW 🙈📏
00:22
Celine Dept
Рет қаралды 94 МЛН
UFC 308 : Уиттакер VS Чимаев
01:54
Setanta Sports UFC
Рет қаралды 849 М.
Remove ALL Unwanted Spaces in Excel (TRIM ALL Function?)
7:49
Leila Gharani
Рет қаралды 382 М.
Using the New IFS Function in Excel
11:10
Technology for Teachers and Students
Рет қаралды 151 М.
Master the IF Formula in Excel (Beginner to Pro)
11:16
Kenji Explains
Рет қаралды 506 М.
Left, Right, Mid, Len, Find and Concatenate Function
11:43
Microsoft Office Tutorials
Рет қаралды 68 М.
MS Excel - Text Functions
9:49
TutorialsPoint
Рет қаралды 1,2 МЛН
SUMIF Function in Excel Tutorial
11:27
Kevin Stratvert
Рет қаралды 266 М.
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 7 МЛН
Beginners Guide to Excel Macros - Create Excel Shortcuts
14:35
Technology for Teachers and Students
Рет қаралды 527 М.
When Should You Use the Hash Sign in Excel Formulas?
10:53
Leila Gharani
Рет қаралды 1,1 МЛН
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 7 МЛН
MY HEIGHT vs MrBEAST CREW 🙈📏
00:22
Celine Dept
Рет қаралды 94 МЛН