How to the number with delimeter

Help Automation Ops
,
4

Okay @anjani_priya

→ You can use the for each excel row activity to iterate the each row in the excel.
→ Inside for each excel row activity insert the Assign activity and give the below expression,

- Assign -> CurrentRow("ColumnA") = CurrentRow("ColumnA").ToString.Split(":").First

Note: Change the column name in the expression as per your requirement.

Hope it helps!!