The Trim Ref operator is a simpler shorthand version of the TRIMRANGE function, and I'll cover this later in the article. The TRIMRANGE function has three arguments: =TRIMRANGE( a b c where If you ...