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

[thima (Himabindu)]

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)

[1996 (Neelima G)]

Hi @thima,

Refer these below articles for split cell values in Seperate cells

Split the cell values in different cell

HI, I have to split the cell values. Its containing multiple name and email ids which will be dynamic. Suppose If one cell containing 2 names and 2 email ids then it should split in 4 cell. first name then first email then second name and second email. I am attaching the input format and sample output format. Please provide the sample workflow. Urgent help would be appreciable. Input.xlsx (10.3 KB)

Split excel cell values separated by delimiter to multiple rows

@Shailesh123, So are you expecting the output like the following, [image]

Thanks,
Neelima.

[Manish540 (Manish Shettigar)]

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.