Want to change 1,2,00.00 to 1200 in excel

Want to change 1,2,00.00 to 1200 in excel

Hope this expression would help you
Str_output = split(Str_input,”.”)(0).Replace(“,”,””)
The we can use this str_output to be entered in excel either with write cell or with assign actinside a for each row loop

cheers @keshav

Hello @keshav

You can use this component to do it easily without much coding.

1 Like

Hi @keshav

Use String Format Activity

Thanks
Ashwin S

Thank you
@Palaniyappan
@AshwinS2
@Lahiru.Fernando

Will try all these solution.

Cheers,
Keshav

2 Likes

Hi @keshav,

Here is an activity to change the cell format in the excel.

Regards
Balamurugan.S