Those curly brackets in Excel aren’t a glitch — here’s what they actually mean
https://www.makeuseof.com/curly-brackets-in-excel/
- Legacy array formulas
The curly brackets you can’t type yourself - Array constants
The curly brackets you do type yourself - Modern Excel and the shift to dynamic arrays
No more Ctrl + Shift + Enter
See also:
- Dynamic array formulas and spilled array behavior – Microsoft Support
https://support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531 - Guidelines and examples of array formulas – Microsoft Support
https://support.microsoft.com/en-us/office/guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7 - Create an array formula – Microsoft Support
https://support.microsoft.com/en-au/office/create-an-array-formula-e43e12e0-afc6-4a12-bc7f-48361075954d