Hi, I have 10 records in excel and i want to apply Fixed with menu in this records to split mobile numbers (Ex-91 5576567564)like this. Can anybody tell how to use text to column
Hi @gauthamRPA
- Read the data into datatable
- Add new datatacolumn for mobile number
3.then use for each row in datatable - Inside loop use assign
‘Currentrow("newcolumn") = currentrow("oldcolumn").substring(3)
- Another assign
Currentrow("oldcolumn") = currentorw("oldcolumn").substring(0,2)
6 .write data back to excel
Cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.