Forum Discussion
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.e., the function tests every cell in the column for spaces and then trims those spaces-however, the function returns some text. The question is: does the function stop after fixing the first cell with space/s (it finds) and return the corrected value, or does it continue to fix the whole following cells to the end of the column?
5 Replies
- OK
The TRIM() function only accepts text or single cell address as an argument. It deals with this cell and returns the fixed(corrected) text in either case (no extra spaces or extra spaces). So, we do need a loop in order for TRIM to deal with the whole column>- Thank you Patric, you are right . But what about huge amount of data ?
does it still perform well?
Use TRIM(A:A).
@ is used for implicit intersection reference. It will work only adjacent cells.
