Introducing formula completion - A new way to write formulas in Excel using Copilot

Hi Lev

this all looks very interesting.

However, I wondered whether in your first example of generating month name with “mmm” you will give any thought to having an alternative. That solution, which we have had forever, produces a month list which sorts alphabetical Apr, Aug etc.

This is about as useful as a chocolate teapot, and now, in Excel’s 40th year, it

would be nice if we could have a TextC function using mmm but giving us a correctly calendar sorting of months.

Regards 

Roger Govier

Former Excel MVP