Blog Post

Excel Blog
3 MIN READ

Announcing TRIMRANGE and accompanying trim references

JoeMcDaid's avatar
JoeMcDaid
Icon for Microsoft rankMicrosoft
Aug 28, 2024
I’m excited to announce a new function, TRIMRANGE, and a set of new reference operators.   NOTE: This is a preview function. Its signature and results may change substantially before being broadl...
Updated Aug 28, 2024
Version 5.0
blog
excel
agwright675's avatar
agwright675
Copper Contributor
Sep 07, 2024

I am on the beta channel:

Microsoft® Excel® for Microsoft 365 MSO (Version 2410 Build 16.0.18028.20004) 64-bit

Everyone else I know who has this build has TRIMRANGE, but I do not - why???
I can see lots of uses for this and it's an improvement on TOCOL().