Hi All,
I have input sheet and one column cell values are multiple how to split and write it in separate cells.
Regards,
Himadata.xlsx (7.9 KB)
Hi All,
I have input sheet and one column cell values are multiple how to split and write it in separate cells.
Regards,
Himadata.xlsx (7.9 KB)
Use this below code to get all values as splitted @thima
System.Text.RegularExpressions.Regex.Matches(TestDt.Rows(0)(“Telephone Number”).ToString,“\d+”)
And then use write cell to add the values to excel.