How to remove extra space in excel

[tkiran (Kiran T)]

Can anyone please help me how to remove extra space in excel when i tried to use it is not working

[Lakshay_Verma]

Hi @tkiran
use assign as
row("DS1")=row("DS1").tostring.trim

and afterwards use write range

[tkiran (Kiran T)]

Thanks a lot… it works fine