TRIMRANGE

TRIMRANGE(range,[row_trim_mode],[col_trim_mode])

Returns the array after excluding all empty rows and/or columns from the outer edges of a range.

range	The range (or array) to be trimmed.
row_trim_mode	(Optional) Determines which rows should be trimmed: 0 = None 1 = Trims leading blank rows 2 = Trims trailing blank rows 3 = Trims both leading and trailing blank rows (default)
col_trim_mode	(Optional) Determines which columns should be trimmed: 0 = None 1 = Trims leading blank rows 2 = Trims trailing blank rows 3 = Trims both leading and trailing blank rows (default)

REMARKS

* For an illustrated example refer to the page under Data Functions
* This function was added in Microsoft 365 (version 2504, first released October 2024).
* The same functionality can also be achieved using the "Trim References".
* Trim References can be applied by replacing a range's colon ":" with either (.:.), (:.) or (.:)
* link - techcommunity.microsoft.com/t5/excel-blog/announcing-trimrange-and-accompanying-trim-references/ba-p/4230202
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=TRIMRANGE(A1:E10,2,2)