Forum Discussion

TilalOsman's avatar
TilalOsman
Copper Contributor
Apr 29, 2023
Solved

TRIM() fuction

When using a range as an argument for TRIM () function (example: TRIM(@A:A)); it is supposed that TRIM () function will eliminate spaces from the whole text in the A column (each individual cell)- i....
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Apr 29, 2023

    TilalOsman 

    So, we do need a loop in order for TRIM to deal with the whole column. NO:

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 29, 2023

TilalOsman 

Use TRIM(A:A).

@ is used for implicit intersection reference. It will work only adjacent cells.

 

Resources