Search for particular String in excel and add another value as an index

hello,guys

for example
i’m searching for “COMPANY” in a excel, where ever i find i’ve to write “NAME” to it so the cell looks like “Company Name” so the excel may contains 100’s of “COMPANY”

Thanks in Advance

Hi @Pradeep_Shiv,

I have developed the workflow according your requirement…

1.The excel sheet1 contains the sample excel.

2.The sheet2 contains the required output.

3.You can even write it in the same sheet.

4.I used only one data table for working effectively.

forum.zip (25.9 KB)

If you find it useful, please mark it as solution and close the thread…

Any doubts let me know…
Cheers.
Vashisht.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.