How to delete the part of string

[Kavyasri (Kavya)]

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…

[Pradeep_Shiv]

Hello @Kavyasri,

Good Day!

As per the requirement, I’m attaching the files here

Cheers
@Kavyasri

Test1.xlsx (8.3 KB) Remove From Cell.xaml (7.8 KB)

[Kavyasri (Kavya)]

Its working,Thank you so much @Pradeep_Shiv

[dfilipovic (Dino Filipović)]

Hi @Kavyasri,

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.

Matches

It is better to try yourself then others to build it for you.

Happy automation,
Cheers,
Dino

[Pradeep_Shiv]

Glad!

Close the topic marking it as a solution!

Cheers
@Kavyasri

[Kavyasri (Kavya)]

Thanks for the suggestion

[Kavyasri (Kavya)]

yeah sure