I have a cell values in many Cell where there are more than one extra (unwanted) spaces, and to explain my problem, am showing it (only for illustration purpose) such spaces with "_".
So, if my cell value (A1) is John_,
while using TRIM(A1), i get result as John
above is perfectly alright,
But, if i have cell value (A1) is John___ (3 blank spaces), only one space is removed, and using TRIM(A1), i get the result like John__ (only one space is removed).
Is there any solution, any substitute to TRIM, which can remove all extra blank spaces