How to remove space from excel cell using Micro

Help
, ,
1

Hello Guys,
How to remove single space from cell using micro, i have tried so many ways but didn’t succeed. Plz help

image
image1366×768 59.3 KB

2

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.

image https://www.techonthenet.com/excel/formulas/images/trim001.png

  1. Copy the column I to the Column A

  2. Clear the contents of Column I

Regards,
Karthik Byggari