The three new dynamic array text functions take collective aim at a class of age-old and related spreadsheet problems – namely, how to separate, or parse, a cell containing a text string into its constituent words.
The prevailing instrument of choice for meeting that challenge was of course, and probably still is, the storied Text to Columns option, shown in Figure 10-1.
A screenshot of a tab titled convert text to columns wizard - step 2 of 3. Among the ...
Get Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.
