Microsoft Excel can now store multiple values in a single cell

Microsoft is testing a major change to how Excel stores data, allowing a single cell to hold multiple values without combining them into one block of text. The new capabilities include lists, arrays and nested arrays, giving users more ways to organise related information within a single spreadsheet cell.

The features are currently available as previews through the Excel Beta Channels for Windows and Mac. Microsoft has warned that the behaviour could change before the tools become generally available and advises users not to rely on them in important workbooks…