TRIMRANGE
Scans in from the edges of a range or array until it finds a non-blank cell (or value), and returns the trimmed result
Syntax
TRIMRANGE(range, [trim_rows], [trim_cols])
Parameters
- range: Required. The range or array to trim
- trim_rows: Optional. 0=don't trim rows, 1=trim leading, 2=trim trailing (default), 3=trim both
- trim_cols: Optional. 0=don't trim columns, 1=trim leading, 2=trim trailing (default), 3=trim both
Example
=TRIMRANGE(A1:E10)