Removing leading and trailings spaces from cells in excel.

Sometime our data contain unwanted leading and trailing spaces in excel. But dont be panic. Removing it is very simple. Yuo can use formula


=TRIM(A1)   where A1 represent corresponding column name.
 






Simple.. isnt it????