Microsoft Excel gurus, your prayers have been answered — more than one value can now be in a single cell as a new…

https://cdn.mos.cms.futurecdn.net/kxGcpkxoakTVcbb7Qb8YNB-1920-80.png
  • Excel cells used to just be for one value – but multi-value lists are soon to be supported
  • Windows and Mac users can now try it out in beta
  • You'll still have to specifically insert a list

Microsoft Excel has just seen one of the biggest updates to its cell architecture since launching, as users can now add multiple values into one single cell.

Until now, users have been unable to add comma-separate text, such as lists, into one cell, but a helpful update to the spreadsheet software is about to change that forever, with Excel not only seeing it as one text string, but also understanding that each item in a list is a separate value.

Introducing lists, arrays in cells and nested arrays as new features, Excel Senior Product Manager Jake Armstrong explained: "You can keep those values in one cell, while also keeping them separate for...

Copyright of this story solely belongs to www.techradar.com. To see the full text click HERE