How to remove single space from cell using micro, i have tried so many ways but didn’t succeed. Plz help
In a macro or using activities -
- Apply the formula on column I , =TRIM($A1) and extend the formula to the last row.
TRIM function will remove the trailing and leading spaces.
Copy the column I to the Column A
Clear the contents of Column I