How to Remove Spaces in Excel (Two Useful Ways)

In today’s tutorial, we’re gonna go through two helpful ways how to remove spaces in Excel. The first one comes handy when you need to ‘tidy up’ numbers or continuous chunks of text. The second one is perfect for texts consisting of two or more words where you just need to remove the leading or trailing spaces, but you want to keep a space between the words.

Don’t miss out a great opportunity to learn:

How to Remove Blank Rows in Excel - BASIC

How to Remove Blank Rows in Excel - ADVANCED

================

❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron

================

⏱️Timestamps⏱️
0:00 Intro
0:46 The First Way How to Remove Spaces in Excel
2:10 The Second Way How to Remove Spaces in Excel (Using the TRIM Function)
3:48 How to Copy the Data Correctly to See the Values not the Function

================

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :)

Transcription How to Remove Spaces in Excel (Two Useful Ways)

Got Microsoft Office 365? Get it here

Connect:

Screen Recorder & Video Editor:

#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

[crystal]

I'm not skipping your ads as my token of gratitude. Your tutorial is way easier to understand, simple and direct unlike other long videos but I still don't understand them. Thank you! you saved my time

[ElectricLadyland]

Liked and subbed! After searching for a good 15 minutes and reading all sorts of articles and answered questions that still didn't quite make it simple, I found this video, which is about as concise and helpful as it gets! Thanks.

[lukasdillon]

Thanks very much for this. This video helped me clean up data for my college major research project.

[apostolis_]

Excellent and helpful explanation!!! Thank you!

[ahmedrahoo]

Very useful video, it helps me a lot. Thanks

[hrzctgbd]

Thank you very much, how can i do it in power query.

[remy]

Like! I didn't know the Trim function could remove the extra space like that.

[veerwave]

sir even in trim the initial space is not getting removed.. please advice.. example the word is like this ' PTS079' ... i want to remove the space which before the letter 'P'.

[koschi]

nice tutorial, but it doen't helped... I tried both variants...
5CB0N82240
5F10M13933
5B10L45935

There was empty space in the end. I was not able to remove it. 😞
Tried to copy it to Notepad, than back to Excel, tried to use CTRL+H and replace => We couldn't find anything to replace....
The Trim function did not do any change the empty space left there...

[abdousamadhydara]

Hello! Nice tutorials. How can you calculate Excel Sheet 1, Sheet 2, an Sheet 3? in Sheet 3 you can do all calculations just like First 1, Second 2, an Third 3?

[nowshadamin]

EL-3668 
There is a space after EL-36688, how to remove this space?

[eduzcopedubai]

hi i dont works to me can you pls suggest another way

[AndroCom]

What about the case like this, Sir .... in to day's tutor ial, we're gonna g o thr ough ??

[vijaypatel]

Showing arrow in every slide and everywhere is irritating