Xpode.com        Click here to Print this article.

Remove spaces between words in excel

I faced this problem when I had to correct the excel sheet of emails. There was empty spaces on left or right of emails.

To remove all spaces of records in:
-Select all the cells in your column
-Select Ctrl+H to open the Replace dialog
--Find what: Press space>
--Replace with:. dont put any thing there.
--Replace All

Empty spaces will be removed and data will be clean


Contributed by:
Rohit kakria
I am software developer

Resourse address on xpode.com

Click here to go on website