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