Excel adds support for multiple values in a single cell · Digg

Excel adds support for multiple values in a single cell

Lists, arrays in cells and nested arrays are arriving first in the Windows and Mac Beta Channels.

1 Source, 2h ago, first seen 2h ago

TLDR

Microsoft is testing lists, arrays in cells and nested arrays in Excel, allowing one cell to hold several distinct values without flattening them into text. The feature can keep related entries such as project owners or survey times together while preserving their use in filtering and calculations. It is initially available in the Windows and Mac Beta Channels, so production workbooks and downstream tools should not assume broad compatibility yet.

Featured Source

Microsoft is testing a change to Excel’s basic data model: a single cell can now contain several distinct values instead of one scalar value or a text string that merely looks like a list.

The Excel Blog announcement introduces lists, arrays in cells and nested arrays. Microsoft says the feature can keep related information together while preserving the individual values for filtering, calculations and analysis.

Why this differs from joined text

Excel users have long packed several items into one cell with commas, semicolons or functions such as TEXTJOIN. That produces one string, so formulas and filters must split or parse it before treating the pieces as separate values.

The new model stores the values as a list or array. Microsoft gives examples such as several owners assigned to one project or multiple time choices returned by a survey. Nested arrays extend the idea by allowing an array to contain other arrays rather than forcing every result into the worksheet grid.

The feature is initially available in Excel’s Windows and Mac Beta Channels. That limited rollout matters for shared workbooks, imports and automation: older Excel builds and external tools may not understand the new value type. Teams should test compatibility before using it in production files or data pipelines.

1 Source

@NeowinFeedExcel just changed the game as Microsoft is now bringing support for multiple values inside one cell. The company has explained in detail. #Microsoft #Excel https://www.neowin.net/news/excel-finally-supporting-multiple-values-in-single-cell-microsoft-explains-how/

Combined views

145

1 Source, first seen 2h ago

Sentiment

Positive——Negative

Summary

Not enough discussion yet.

No sentiment analysis available yet.