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:

TilalOsman's avatar
TilalOsman
Copper Contributor
Apr 29, 2023
Thank you Patric, you are right . But what about huge amount of data ?
does it still perform well?

Resources