Remove All Spaces From The Cell In Excel

By Super Man

Remove all the spaces from the cell , from left , right , in between the content.

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


Remove All Spaces From The Cell In Excel  (2791 Views)