14 New Excel Functions CalCPA Article

Microsoft recently introduced 14 new functions for Excel—they are sure to help you save some time. We’ll start with a short description of each and then jump into some demonstrations.

• TEXTSPLIT: splits text into columns and/or rows based on one or more delimiters.
• TEXTBEFORE: returns the text before the specified delimiter.
• TEXTAFTER: returns the text after the specified delimiter.
• VSTACK: combines multiple tables into one table by stacking them vertically.
• HSTACK: combines multiple tables into one table by stacking them horizontally.
• TOROW: converts a table into a single row.
• TOCOL: converts a table into a single column.
• WRAPROWS: converts a single column (or row) into a table, going across then down.
• WRAPCOLS: converts a single column (or row) into a table, going down then across.
• TAKE: returns only the specified number of rows (or columns) from a table (beginning or end).
• DROP: returns all but the specified number of rows (or columns) from a table (beginning or end).
• CHOOSEROWS: returns the selected row or rows from a table (in any order).’
• CHOOSECOLS: returns the selected column or columns from a table (in any order).
• EXPAND: expands a table to a specified number of rows and columns.

To view the demonstrations and learn more about each function, check out the Full Article Published in CalCPA Magazine.