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.
| COPILOT | (2025) Returns the response based on your referenced data using an AI model. |
| 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. |
| COPILOT (2025) Returns the response based on your referenced data using an AI model. |
| 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. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext