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").