I want to search for “and” in the Department Column and I need to delete the “and” along with its beside words in all the cells of “Department” Column.
Expected Output :
I want Output like this…It would be of great help if anyone suggests me some idea…
As per the requirement, I’m attaching the files here
Its working,Thank you so much @Pradeep_Shiv
for further use you can use this Regex builder which is easy to use and you can see results of your query
With this Action which is available in any automation project because it is a part of standard dependencies.
It is better to try yourself then others to build it for you.
Close the topic marking it as a solution!
Thanks for the suggestion
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.