Filter Excel Column Value Having Multiple Values in the cell

Hi Team,

I have an excel contains one column called Email i want to filter one value ex : "telukuntla.venkatakrishna@aig.com;poojitha.desireddy@aig.com"

I want to filter the above cell value. when i am trying to filter the above value using blueprism Bot is filtering individually both emails and giving result contains Both emails.

Can anyone give the solution for this. attaching screenshot for reference.
 

Attachments

  • Capture.jpg
    13.1 KB · Views: 33
Top