Posted on

Replace Space in excel

This is formula to use in Excel, So put your main data in Column A and put this formula in Column B and just copy and past value from column B — >  Column A. When you paste Value each time it will remove Spaces.