The new feature is called formula completion and it’s powered by AI models to “proactively suggest and autocomplete formulas ...

This tutorial will show you how to create a Formula to Add, Subtract, Multiply or Divide in Microsoft Excel. You can do basic calculations easily!

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.