Sharing some useful tips, solutions and notes for Geeks.

Tuesday, July 23, 2013

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????

No comments: