New Functions in Microsoft 365
You may not have (or see) all of these because some of them are very new and only available to Office Insiders.
| DETECTLANGUAGE | (2024) Preview. Returns the language code for the text string provided. |
| GROUPBY | (2023) Preview. Returns the grouping of your data along one axis and aggregates the associated values. |
| PIVOTBY | (2023) Preview. Returns the grouping of your data along two axis and aggregates the associated values. |
| PY | (2023) Returns the value or object after running code in a Python Editor. |
| REGEXEXTRACT | (2024) Preview. Returns the characters that match the pattern provided. |
| REGEXREPLACE | (2024) Preview. Returns the text string after replacing characters that match the pattern provided. |
| REGEXTEST | (2024) Preview. Returns the boolean True or False depending if the pattern matches any part of a text string. |
| TRANSLATE | (2024) Preview. Returns the text string translated into another language. |
| TRIMRANGE | (2024) Preview. Returns the array after excluding all empty rows and/or columns from the outer edges of a range. |
| DETECTLANGUAGE (2024) Preview. Returns the language code for the text string provided. |
| GROUPBY (2023) Preview. Returns the grouping of your data along one axis and aggregates the associated values. |
| PIVOTBY (2023) Preview. Returns the grouping of your data along two axis and aggregates the associated values. |
| PY (2023) Returns the value or object after running code in a Python Editor. |
| REGEXEXTRACT (2024) Preview. Returns the characters that match the pattern provided. |
| REGEXREPLACE (2024) Preview. Returns the text string after replacing characters that match the pattern provided. |
| REGEXTEST (2024) Preview. Returns the boolean True or False depending if the pattern matches any part of a text string. |
| TRANSLATE (2024) Preview. Returns the text string translated into another language. |
| TRIMRANGE (2024) Preview. Returns the array after excluding all empty rows and/or columns from the outer edges of a range. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext