How To Remove Spaces Between Characters And Numbers Within Cells In Excel

How To Remove Spaces Between Characters And Numbers Within Cells In Excel?

In this tutorial I will be using function to remove all spaces between characters in excel. This is really an easy tutorial. I am using Microsoft Excel 2010 for the demonstration.

Let’s heed towards the step by step tutorial to remove all space from a cell.

Step 1: Open the workbook

Step 2: Write the formula =Substitute(A2," ","") and press enter

Step 3: Drag the formula until end and it’s done.

That’s it and you have successfully removed all space between characters in excel

Hope you like it.

#excel10tutorial #removespace

Thanks for watching.

-----------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------

If you like this tutorial, please subscribe:

Checkout our Advance Excel Tutorial Playlist:

Checkout the Excel Case playlist:

Connect us on social media

[pankilshah]

Thank you for this tutorial, very helpful for me 😊

[DeliveryZoneUAE]

Its giving an error when doing it with numbers. Can you please provide a solution for that

[abbaspatel]

Then How to manage in different brackets?

[altavistasfo]

what about if the 2 words where in the same column?

[SethuSelvam]

It is simpler to just search and replace " " (space) with "" (no space), for the example that you have given!

[fatimabezbiq]

Hello, I tried this formula but without success, do you another way to do it
Thank you

[gopikrishna]

how to remove at the end of cell space in excel

[Haldexify]

i doesnt work for me.. getting an error