Microsoft is making Excel’s formulas easier

If I had to ask for one killer new feature in Excel, it would be to adopt Apple's numbers approach to the design of a spreadsheet. I.e. not one grid per tab, but one canvas per tab, and that canvas can contain multiple elements which can be grids, charts, pivot tables, something else.

Your grids can overflow with a scroll bar, so I can put one table above another one without them colliding when the top one expands.

You can do that in a backward compatible way, if a canvas is not defined on an old spreadsheet, just assume one canvas that contains one grid set to full screen.

It helps presentation, it helps splitting the logic of your spreadsheet in discrete components, I only see upside.

Yep, we have a expensive reporting tool, can too all kinds of things, query every type of database we have...

Number one function used. Export to Excel, and normally it is on reports of basic table join queries, none of the advanced things it can do with the data

For fun, I took this formula and asked ChatGPT to convert it to a VBA Function (with comments):

    Function extractText(cell As Range) As String
        ' Declare an array of search terms
        Dim searchTerms As Variant
        searchTerms = Array("Banner", "EBL2", "Movie Art", "Use as is", "TTT", "Generic")
        
        ' Initialize start and end positions to 0
        Dim startPos As Long
        startPos = 0
        Dim endPos As Long
        endPos = 0
        
        ' Loop through search terms and find the first occurrence of any of them in the cell
        For Each searchTerm In searchTerms
            startPos = WorksheetFunction.Search(searchTerm, cell)
            If startPos > 0 Then
                Exit For
            End If
        Next searchTerm
        
        ' If none of the search terms were found, try finding "Customs" or "Custom"
        If startPos = 0 Then
            startPos = WorksheetFunction.Search("Customs", cell)
            If startPos = 0 Then
                startPos = WorksheetFunction.Search("Custom", cell)
            End If
        End If
        
        ' If none of the above were found, try finding "Generic"
        If startPos = 0 Then
            startPos = WorksheetFunction.Search("Generic", cell)
        End If
        
        ' If none of the search terms were found, return an empty string
        If startPos = 0 Then
            extractText = ""
        Else
            ' Loop through search terms and find the next occurrence of any of them after the start position
            For Each searchTerm In searchTerms
                endPos = WorksheetFunction.Search(searchTerm, cell, startPos + 1)
                If endPos > 0 Then
                    Exit For
                End If
            Next searchTerm
            
            ' If none of the search terms were found after the start position, set the end position to the end of the cell
            If endPos = 0 Then
                endPos = Len(cell) + 1
            End If
            
            ' Extract the text between the start and end positions
            extractText = Mid(cell, startPos, endPos - startPos)
        End If
    End Function

Edit: Sadly this doesn't work at all lol, and after half an hour of prompting ChatGPT can't figure out why, it just gets stuck in a loop :-(

Did you actually try running the code vs the formula and compared it works the same way in the expected cases?

The times I've tried using ChatGPT, it has mostly giving me code that seems like it'd work but doesn't.

You are eventually gonna have to write comments about other things than just plugging your own projects, especially when they are just barely on topic.