Using the Trim Function in Excel

[@nodnalneyugn8753]

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]

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]

Awesome! Very beginner friendly way of teaching. So easy to understand. Thanks so much

[@janebuckland737]

Excellent communication and instruction. No time filling just really useful productive information. Thank you

[@adysyady5527]

God you just saved me a lot of times to do my jobs. Thanks. Big thumbs-up for ur content!!

[@FaysalEasyExcel]

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]

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]

what i love is you provide materials for practice. thanks.

[@joeytang3532]

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]

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]

Thank You very very much Greetings from Croatia

[@junjunmulleda5467]

Love the quick tips. Always easy to learn from your tutorials. Thanks!

[@silviac.929]

This is GREAT. Thank you. Subscribed. Excellent explanation.

[@aramschwartz4502]

Great Video!! Thank you!

[@Suraj_Mehra0211]

That was an amazing and detailed explanation. Thank you for the video!

[@saunderssm]

Great tip! Wish I had known this a while ago!

[@rizalfatoni4075]

"so it removes those extra spaces", finally. Thanks a lot, this helps in saving my time!

[@amirahervol9199]

so easy to understand. Thanks!

[@nw9497]

You're a good teacher

[@adefabrisio8576]

Great Tutorial - Thank you so much in 2021

[@annieudoh1745]

The best among all videos

[@anasser]

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]

Brilliant well showed and easy to follow

[@SeemaSharma-lj3cf]

Thanks for sharing. Very helpful

[@starfish258852]

Thank you very much.

[@batoolfatima9218]

Great video. Very clear explanation. 👍🏻

[@mohammedalsahli1273]

Thank you very much for this video.

[@abdullahabdulwahabfarhanal8496]

Thank you so much👍

[@dheerajdheeraj4429]

Thanks for showing deleting uncleaned data (duplicate data)

[@roopinderrandhawa3996]

Great to the point video !!!

[@brunorivarolla]

Good content and clear

[@Erifon22]

You are a life saver.

[@thouhakheng168]

I love all your videos and also like all your videos😛😛😛

[@lisamars86]

Uhh how did you get my DVD collection list!? Another great video, thanks alot for Posting!

[@abdullahwaseem4321]

Thanks, it was really comprehensive but useful 😘

[@gabrielamarante1796]

Great video, thank you

[@patb8985]

Brilliant! Thank you very much.

[@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]

Thanks, easy to understand.

[@Ateeq10]

thank you so much

[@yapjialer7115]

great tutorial, detailed nad patience :)

[@ruturajpatil914]

USEFUL INFORMATION

[@ouahibabela8986]

Thanks a lot

[@ashishgarggarg5379]

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]

Thank you for your video!

[@realdanafields]

Thank you!!!!!!!

[@bigteno4597]

Brilliant stuff!!!

[@jocyanjocyan6409]

Great, Thanks a lot

[@taylormckenzie8897]

Thank you.

[@bhavinpatel225]

Can we also use proper formula in this situation ?

[@996_SakshiSingh_44]

Thank you

[@slainiae]

How does one trim a date&time column (e.g 01/09/2017 00:02:01)? Thank you.

[@islamelabbady2752]

awesome!

[@newalzebary4301]

thanks

[@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]

Do you have sample for numbers with spaces in between?

[@lifewithshidit]

Awesome👍👍🙏🙏

[@feljunpaquingan17]

Hi, May I ask how to add a Dash "-". example: AB087 becomes AB-087

[@rajsuthar999]

How can the user be prevented from filling such data as in column A.

[@philipgreenfield188]

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]

Thanks

[@khaja7245]

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]

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]

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]

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]

Can't fix the ending spaces in my excel, why?

[@babarali8430]

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]

IS there a way to do this without creating a new column?

[@SIMRANKAUR-eg7nc]

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]

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]

It's not working .... Idk why .... My data still has space at the end of it ? Can you help with it ?

[@khtoday2553]

Hello can you show me how to link comment cell to other cell ?

[@Dr_talbuaia]

please add pagemaker turtorial

[@burak9857]

I tried adding a couple of punctuation errors and tried it. I guess it only works for spacing :(

[@arielsaballa8880]

But first you have to make sure that the whole sheet is on General format coz if not. The formula won't read.

[@Custerd1]

I tried the tips in the video and it wouldn't work - this comment from you helped me. Thank you.

[@ashishdaharwal4427]

Paste special crtl+ alt + V simple

[@GQElvie]

never addressed spaces after the last word, so v lookups do not work.

[@mikegruber172]

could just double click the autofill

[@saiteka]

When single space is in between one name then it doesn't removing single space.

[@stephendehart9777]

NO SOUND!

[@LitoDaBurrito]

thankyou so much

[@marinelamalceva9026]

Very helpful! Thanks!