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

[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.