How to remove text from the excel cell

Duplic.xlsx (8.5 KB)I
I want to delete “JNTU” text from the column “College”.That text needs to be deleted everywhere.Can anyone suggest me any method to do that or upload any workflow if you have

Hi @Kavyasri :wave:

Iterate the DT and use replace() to replace the required text with empty space.

row("College").ToString.Replace("JNTU","")

, I used For each loop to iterate and I used the if condition and took Replace activity(Regex) here,But its not giving correct result…As you gave the suggestion, can you please provide me any workflow of that so I can understand how to use it in my process.

@Kavyasri, try this workflow:

Main.xaml (5.9 KB)

Let me know if you are facing any issues!

It is working Now…Thank you :slightly_smiling_face:

1 Like

No issues @Kavyasri :slight_smile:

I can see that you are new to the community! Welcome! Kindly mark my response as solution so, it can benefit others! Cheers!

Yeah Done :+1:

1 Like

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