Microsoft Excel now supports multiple values, Lists, nested arrays, and new array functions inside a single cell for Insider users.

Microsoft is changing a 40-year-old Excel rule by allowing a single cell to hold multiple values using new lists, arrays in cells, and nested arrays.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here’s how. We all inherit Microsoft Excel sheets that don’t suit our working ...

Microsoft Excel has taken a bold step forward with its latest feature, now allowing cells to store lists, arrays, and even nested arrays. This update, currently in beta for Microsoft 365 Insiders, ...