The NEW TRIMRANGE Function + "The Dot"

Video • 8 minutes

Learning Objectives

Learn how to use the new TRIMRANGE function in Excel 365 to dynamically trim and update cell ranges.
Understand how to apply the dot (.) notation in your formulas to efficiently trim leading or trailing spaces.
Explore how to combine multiple ranges vertically using the VSTACK function.

Lesson Description

Struggling with messy lists in Excel? Learn how to clean up your data using the new TRIMRANGE function in Excel 365. It automatically removes extra blanks and keeps your lists up to date without manual fixes or unwanted zeros.We’ll also show you a clever trick using “the dot” (.) in formulas for quick and easy cleanups. It's a simple way to make your Excel workflow faster and cleaner.

Design Better Spreadsheets in Excel: 5 FAST Tips!