Let Sharyn show you two quick ways to remove extra spaces in an Excel cell.
@tommyharris5817
2 жыл бұрын
Thank you. This has got to be the biggest frustration in Excel! I was just about to give up even after trying the TRIM function which didn't delete all the spaces. I used the =RIGHT function to identify the extra spaces at the end of the cells and had to manually delete them!
@ExcelatWork
2 жыл бұрын
Hi Tommy. I totally agree! Sometimes we need to deal with hard-spaces that TRIM doesn't remove. You might like to check out my vide on these. You can find it here kzitem.info/news/bejne/qJeO1ndsopGKp4o. I hope it's helpful to you.
@aidansalmeron1714
Жыл бұрын
Very helpful and explanatory video! Thanks so much!
@ExcelatWork
Жыл бұрын
You're very welcome Aidan!
@sarahmwale1092
2 жыл бұрын
Thank you so much,this has really helped me and saved my time today.
@ExcelatWork
2 жыл бұрын
That's fantastic. So glad it helped.
@Eselkay1989
Жыл бұрын
Very good! Thank you Sharyn for this tutorial. I guess your first 'like' comes from me. 😊😊
@ExcelatWork
Жыл бұрын
Yay! Thank you!
@johanpersonalgmail9186
Ай бұрын
Thank you
@ExcelatWork
24 күн бұрын
You're welcome
@winsoe1658
2 жыл бұрын
Thanks much, it is very useful for cleaning data
@ExcelatWork
2 жыл бұрын
Glad it was helpful!
@isaganiregio4847
Жыл бұрын
thank you. Such a big help
@ExcelatWork
Жыл бұрын
You're welcome! I'm so glad it helped!
@hemarahate
2 жыл бұрын
Helpful. Thanks
@ExcelatWork
2 жыл бұрын
Glad it was helpful!
@haphappablap7684
2 ай бұрын
BAM! and the space is gone. Thanks!
@ExcelatWork
24 күн бұрын
Yay! That's awesome!
@sayanahmed4470
Жыл бұрын
Thanks
@ExcelatWork
Жыл бұрын
You're very welcome!
@anthonyelliott8092
8 ай бұрын
i tried this, the spaces at the end remain. what am i doing wrong?
@Retcon__
5 ай бұрын
She didn't actually tell us how to remove the space from the column. Confusing title.
@bilalaziz137
2 жыл бұрын
If we want only remove space form the right "Steve Job "" then?
@ExcelatWork
2 жыл бұрын
The Trim function will only remove unnecessary spaces. This means that the space between Steve and Job will remain, but the unnecessary space to the right will be removed.
@YG-zv3me
3 ай бұрын
Doesn't work. I ended up coping the entire column with the space at the end of each cell, and pasting it into a blank word file, and then proceeded to do the find and replace thing after which I copied and pasted it back to the excel sheet, and only then did it work!
@georgianarundgren2385
Жыл бұрын
It isn't working for me. I have a column of over 500 links to our companies' internal files and I can't get that 1 trailing space to go away. To be clear all these files are coming from 1 agent. The files from other agents I can trim just fine. They are all on the same spreadsheet when they come to me to work. So confused.
@prasidhkumar6056
2 жыл бұрын
How to trim spaces from the start of the text?
@prasidhkumar6056
2 жыл бұрын
Trim function is not working in that case
@ExcelatWork
2 жыл бұрын
Hi Prasidh. Please check out my video on How to remove spaced TRIM misses kzitem.info/news/bejne/qJeO1ndsopGKp4o :-)
Пікірлер: 35