How to remove string

Hw can i remove alphabets ‘Rs’ from ‘Rs.89,600.0’… i need to keep only numbers in the column of my excel file


Check as below

For writing back to excel, check as below for your reference

Hope this helps you


how can i do this for whole column of ‘Due amount’

Use Read Range to Read Data and then Use For Each row
In that use assign Activity
row(“Due Date”)=row(“Due Date”).Tostring.Substring(3)
After For Each use Write Range

use this System.Text.RegularExpressions.Regex.Match(inputString, “\d+”)


Check below workflow (13.2 KB)

Mark as solution if this helps you


it’s working
thank u

row(“Due Amount”).ToString.Substring(3,row(“Due Amount”).ToString.Length-3)
could u plz elaborate this


Regarding Substring, you can visit below link

check the post which resolves your query and mark that post as solution


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.