Skip to content

Support for TRIMRANGE and Trim Refs operator #2311

@swmal

Description

@swmal

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions