Excel now supports multiple values in a single cell
Microsoft has added a new feature to Excel that allows users to enter multiple values in a single cell. The feature, which was first spotted by a Reddit user, allows users to separate values with a comma, semicolon, or other delimiters to store multiple values in one cell. This feature is available in the latest version of Excel for Windows, and users can access it by selecting the cell, typing the values separated by a delimiter, and pressing Enter. The values will be stored in the cell as a list, and can be easily manipulated and referenced in formulas. This feature is expected to be a game-changer for users who need to store multiple values in a single cell, such as data analysts and power users. The feature is currently only available in Excel for Windows, but Microsoft has not ruled out rolling it out to other versions of Excel in the future.
Read the full article at techcommunity.microsoft.com →