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) Returns the language code for the text string provided.
GROUPBY	(2023) Returns the summary table after grouping and aggregating by row.
PERCENTOF	(2023) Returns the percentage that a subset makes up from a given data set.
PIVOTBY	(2023) Returns the summary table after grouping and aggregating by row and column.
PY	(2023) Returns the value or object after running code in a Python Editor.
REGEXEXTRACT	(2024) Returns the characters that match the pattern provided.
REGEXREPLACE	(2024) Returns the text string after replacing characters that match the pattern provided.
REGEXTEST	(2024) Returns the boolean True or False depending if the pattern matches any part of a text string.
TRANSLATE	(2024) Returns the text string translated into another language.
TRIMRANGE	(2024) Returns the array after excluding all empty rows and/or columns from the outer edges of a range.

DETECTLANGUAGE (2024) Returns the language code for the text string provided.
GROUPBY (2023) Returns the summary table after grouping and aggregating by row.
PERCENTOF (2023) Returns the percentage that a subset makes up from a given data set.
PIVOTBY (2023) Returns the summary table after grouping and aggregating by row and column.
PY (2023) Returns the value or object after running code in a Python Editor.
REGEXEXTRACT (2024) Returns the characters that match the pattern provided.
REGEXREPLACE (2024) Returns the text string after replacing characters that match the pattern provided.
REGEXTEST (2024) Returns the boolean True or False depending if the pattern matches any part of a text string.
TRANSLATE (2024) Returns the text string translated into another language.
TRIMRANGE (2024) Returns the array after excluding all empty rows and/or columns from the outer edges of a range.