Remove All Spaces From The Cell In Excel

Here we make use of substitute function to remove all spaces from the cell

For example,
Cell       A5       has value like “       12 34 56 78 st tin sd   ”

Then formula

=SUBSTITUTE(A5," ","")


It will give output as

12345678sttinsd