Tag Archives: Excel 365

Excel 365 – new text function TEXTSPLIT

New text functions have recently been added to Excel 365. The TEXTSPLIT function works in very much the same way as Data – Text to Columns. The syntax is =TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode] [pad_with]) Only the first two bits … Continue reading

Posted in Excel 365, Microsoft Excel | Tagged , | Leave a comment

Excel 365 and Excel 2021 – the Filter function

The FILTER function is new in Excel 365. When we use the Filter dropdowns we see the results as part of the data set but the new FILTER function allows us to easily create a subset of that data somewhere … Continue reading

Posted in Excel 365, Microsoft Excel | Tagged | Leave a comment