How to remove whitespaces in the excel

[ushu (Usha kiranmai)]

Hello @Chippy_Kolot Please refer below thread

Removing spaces in Excel

Hello Everyone, I have used all methods like Trim, Substitute and clean to replace the spaces with empty character but failed. Please find the attached excel file with the sheet name : Sheet1 and Column L Can some one please help me on this to remove all spaces within excel.RemoveSpaces.xlsx (9.2 KB) Thanks a lot in advance. Regards VishnuRemoveSpaces.zip (20.5 KB)