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....
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>
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?