On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a ...

This poses a problem when you actually need to concatenate the double quotation marks themselves. However, Excel has a special character function that allows you to enter such marks.

If you do, Excel will give you a circular reference warning. Type this function in the cell, including the quotation marks but excluding the final period: =COUNTIF (cell range, "phrase").

Microsoft is testing out a new =COPILOT function in Excel cells – it's in beta with improvements needed, but you can try it ...