Currently in beta, Excel can now include entire lists within a single cell and still understand that they contain multiple values.
While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such cases, Excel's LOOKUP function can be extremely useful. It allows you to ...
25don MSN
Microsoft finally fixes this annoying Excel paste problem, but you probably never even noticed
A limited set of users with Excel 2016 and other standalone Excel purchases have been struggling to paste.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results