Excel/Spreadsheet: How to remove white space within sentences?

on

Questions:

I'd like to remove all the white spaces in the sentences for specific column. How to do that using formula?


Answers:

The formula to remove all the white spaces in the sentences is as below.

=SUBSTITUTE(<PutYourReferencesColumn>,<CurrentTextOrCharactersToBeReplace>,<NewTextToBeReplace>)

--To remove all white spaces
=SUBSTITUTE(A2," ","")


--Advanced: You can also replace certain text to another text!
=SUBSTITUTE(A2,"Hi","Hello")