Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     

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
Share this article   |    Print    |    Article read by 2757 times
Rohit kakria
I am software developer
Related Articles: No related article
Related Interview Questions: No related interview question