Forum Discussion
Searching text in Excel with CoPilot
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?
- As Copilot in Excel is still in preview mode, the current functionality are listed here; https://copilot.cloud.microsoft/en-us/copilot-excel
