I have an excel with 2 columns name and age. with age having details like #A20#, #A3# etc. i want to trim characters on age leaving details which are in between A and # for example #A20# will be 20. what i have done so far is
-read range and used for each row
-used assign row.Item(1).toString which is age column
-txtvalue.Substring(1,4) to trim
My question is is there any way fast to trim the details because its taking too long for 200 rows. and also how can i write the value i have trimmed on that same cell.
TRIM.xlsx (7.9 KB)