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????
=TRIM(A1) where A1 represent corresponding column name.
Simple.. isnt it????
No comments:
Post a Comment