How to remove space from excel cell using Micro

Hello Guys,
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 -

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


  1. Copy the column I to the Column A

  2. Clear the contents of Column I

Karthik Byggari