How to split excel cell multiple values and write in single cell

Hi All,

I have input sheet and one column cell values are multiple how to split and write it in separate cells.

Himadata.xlsx (7.9 KB)

Hi @thima,

Refer these below articles for split cell values in Seperate cells


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.

1 Like