How to remove empty spaces from the numbers

I have spaces in my excel column. how can i remove the spaces, I tried with Trim but it is not working.
for ex:
1 2345
12 2345
1 6789
123 12
Can any one please help me to fix this issue.


How about Replace method, as the following?


yourString.Replace(" ","")


Hello @Chippy_Kolot ,
Kindly refer this regex expression. It will remove any whitespace betweeb the values

System.Text.RegularExpressions.Regex.Replace("12   234   5","\s+","").ToString

Var1=“12 234 5”



use .replace(" ",string.empty)

Hi @Chippy_Kolot, I hope you are doing well.
For your current problem I am attaching an workflow for your reference which might help you to get a solution and understand.
Main.xaml (11.0 KB)

Have a good day!

Thanks & Regards,
Shubham Dutta