New Excel functions

[swmal]

WRAPROWS function

https://support.microsoft.com/en-us/office/wraprows-function-796825f3-975a-4cee-9c84-1bbddf60ade0

WRAPCOLS function

https://support.microsoft.com/en-us/office/wrapcols-function-d038b05a-57b7-4ee0-be94-ded0792511e2

REGEXEXTRACT function

https://support.microsoft.com/en-us/office/regexextract-function-4b96c140-9205-4b6e-9fbe-6aa9e783ff57

REGEXREPLACE function

https://support.microsoft.com/en-us/office/regexreplace-function-9c030bb2-5e47-4efc-bad5-4582d7100897

REGEXTEST function

https://support.microsoft.com/en-us/office/regextest-function-7d38200b-5e5c-4196-b4e6-9bff73afbd31

TRIMRANGE function

TRIMRANGE(F:F) - trims a range, removing leading/trailing/all empty rows/cols.

Trim Refs operator

A1.:B10 (leading trim) → corresponds to TRIMRANGE(A1:B10,1,1)
A1:.B10 (trailing trim) → TRIMRANGE(A1:B10,2,2)
A1.:.B10 (full trim) → TRIMRANGE(A1:B10,3,3)

See https://techcommunity.microsoft.com/blog/excelblog/announcing-trimrange-and-accompanying-trim-references/4230202

FORECAST.ETS function

https://support.microsoft.com/en-us/office/forecast-ets-function-15389b8b-677e-4fbd-bd95-21d464333f41

FORECAST.ETS.CONFINT

https://support.microsoft.com/en-us/office/forecast-ets-confint-function-6d4a7557-11fa-4678-9e6a-dbcc31a7c7df

FORECAST.ETS.SEASONALITY

https://support.microsoft.com/en-us/office/forecast-ets-seasonality-function-32a27a3b-d22f-42ce-8c5d-ef3649269f3c

FORECAST.ETS.STAT

https://support.microsoft.com/en-us/office/forecast-ets-stat-function-60f2ae14-d0cf-465e-9736-625ccaaa60b4

Text/Web/Utility

ASC

https://support.microsoft.com/en-us/office/asc-function-0b6abf1c-c663-4004-a964-ebc00b723266

CODE

https://support.microsoft.com/en-us/office/code-function-c32b692b-2ed0-4a04-bdd9-75640144b928

ENCODEURL

https://support.microsoft.com/en-us/office/encodeurl-function-07c7fb90-7c60-4bff-8687-fac50fe33d0e

USDOLLAR

https://support.microsoft.com/en-us/office/usdollar-function-cf756103-59e4-40a8-a78e-994c4e4243ad

Information/Inspection

CELL

https://support.microsoft.com/en-us/office/cell-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf

FORMULATEXT

https://support.microsoft.com/en-us/office/formulatext-function-0a786771-54fd-4ae2-96ee-09cda35439c8

ISFORMULA

https://support.microsoft.com/en-us/office/isformula-function-e4d1355f-7121-4ef2-801e-3839bfd6b1e5

SHEETS

https://support.microsoft.com/en-us/office/sheets-function-770515eb-e1e8-45ce-8066-b557e5e4b80b