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)