Remove ALL Unwanted Spaces in Excel (TRIM ALL Function?)

This is an excellent video. Got right to my issue.

Leila, you rock! I've tried all the quick and easy ways of solving this issue and all failed. Finding the right character did the trick. Thanks a ton! Subscribed!

Thank you

As usual one stop solutions to all my excel problems.. 🎉Thanks Leela

Thank you so much. Your tutorials are so useful, very easy to follow and understand.

Question, when you use "RIGHTT" function, it usually has a space. Is that 160 or 32?

How to do it in power query?

so amazing , very long time i was looking thank you so much

god, woman, i love you! thank you for your smartness

Hello, I am having difficulties trimming unwanted spaces.
Please help.

"Open ⋅ Closes 10 pm · 026642 07478575 45814" - How to remove spaces in this & how to extract the no only from this example ?

Thanks you very much!

Thanks

Hey,I just waana say that thank u very much.

Thank you so much! Couldn’t figure it out until the code portion, ours was code (9) and once we figured that out, piece of cake!

thank you soooooo much, it appears that i had an other type of space, code() gave me 10, i have no idea what kind of char is that but the same logic worked for me

excellent very good ... love u . its solve my many many😘 issues.😍

That's great. Highly appreciated

I just simply used "=CLEAN(TRIM(A1))" for my needs and it worked. But I guess from other posts that doesn't work with char 160 or ASCI 160 or whatever it is lol

OMG THAT's Why!!! Thank you thankyou!!! 😂

All I can say is that "Its a great video"..

You saved me!!!!

Very useful video! I learned a lot. I had no idea about any of these functions!
The only easier way I could do this sort of thing is by using Power Query :-

Wow, thank u so much

Awesome !!! Thanks

Thanks very useful✨✨

great trick, thank you very much, all you videos are briliant

Thank you so much. I was ready to kick my computer after 2 hours of work I thought was going to be unusable.

It helps a lot. Thank you!

Mam, this formula for remove space in numbers is not working on office 365 but the same was working on 2013, is there is application issue

QUESTION - Can you trim values pasted into the CTRL+F Find/Replace field? Let's say I have "Microsoft" in a cell in Excel, but I copy "Microsoft" from Outlook and do a search, typically Microsoft will add a space at the end and that extra space will cause issues. Is there a way around this besides manually deleting extra spaces at the end? Awesome video. Subbed a LONG time ago and you've helped me (and many others I send to your channel).

Please let me know ,how can check all space are remove

this was a super help for me i used this today & fixed a lot of issues with spaces on my spreadsheet. thanks so much for your time and detication for these tutorials they are a really help for a lot of people worldwide !!!! awesome work !!!

As usual, blew my mind. thank you!!

Propertyware elects to add a table character at the end of a cell if copied and pasted directly form the website (not from a generated report). Took a minute to track that down. You can use =LEFT([cell address],LEN([cell address])-1) to ensure that the report generated name matches the copied and pasted name.

Chars 0 - 32, 160, and then there are some numbers way up there in Unicode that are also whitespace.

this was my exact problem. i imported some DJIA stock data into excel, tried using a sum function on it, didnt work. noticed there was a space in front of each number, tried the trim function to get rid of them, copied those cells to new cells as values to then sum those, still didnt work. then the char 160 substitute did work, so i pasted those answers as values to new cells, tried to sum those new cells, still didnt work. then i referenced my substitute char 160 cells in new cells with a value function, pasted those answers to new cells, summed them, and the sum function finally worked.

all this because of a space in front of these numbers.

Hi Leila, thanks for this. I tried Google Sheets and it was smart enough to quickly remove the blank space that Excel had great difficulty removing. I used "Find and Replace" in the edit menu to remove currency abbreviations and space in numbers I copied from my bank's website. I assume that Google Sheets' trim function is likely to work easily too.

It works... thank you to the max !

I just used this function to solve a problem with my data, thanks Leila.

This video changed my life right now 🤩 This is very helpful. Thank you so much!! 😇

she is genius...

I will forget your help Leila. Thanks

Thank you so much it was very helpful

Leila, you are truly my HERO, I SO APPRECIATE YOU! This lesson has just allowed me to save 4hours of formatting. Thank you, thank you, thank you.

You are a lifesaver!

Excellent! Although SUBSTITUTE did not work for my specific issue i found that pasting code 160 in "Find and replace" solved my issue. Also I can see now that it's exactly what earlier commenter Thiago suggested.

how to use trim fromula with sumproduct mulit condition

Very well explained.Thank you 🙏

Great!
I was looking for how to remove spaces from a value and found the solution.
Thanks Leila