Deleting blank spaces from a data table



Hello !

I am looking to delete the blank spaces from a certain column in my Datatable.
I the column, i have data written like “71 111” and I would like to be able to have “71111” so I can use it as an integer for further processing.

If possible, i would like to avoid interaction directly with the excel file (send hotkey, find and repalce , etc …).

Any ideas ?

Best regards,


get the value to a temp variable
create assign temp=temp.Replace(" ","")
now temp will have value without spaces.


Perfect ! Thanks !