Wednesday, November 14, 2012

Trim spaces

=trim(A2)
The excel formula above will remove spaces in front and behind any text or number or date value. It does not remove spaces in between.

0 comments:

Post a Comment

www.cineclouds.com. Powered by Blogger.