Searching text in Excel with CoPilot

[Zabeltann]

I'm trying to get CoPilot to search thru a text column in a table and pull out certain data to another column, but I'm not succeeding. Instead it searches and replaces text. I'm trying prompts like "Search A column and copy text similar to "Sold 8 of product X" into C column. Any hints?

[#2]

As Copilot in Excel is still in preview mode, the current functionality are listed here; https://copilot.cloud.microsoft/en-us/copilot-excel

[#3]

@Ankur_B , I understand. Thanks!