skip to main | skip to sidebar

Excel Geek

Showing posts with label excel trim spaces formula. Show all posts
Showing posts with label excel trim spaces formula. Show all posts

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.
Read More..

Posted by Raj Kumar.G at 1:58 AM 0 comments
Email This BlogThis! Share to X Share to Facebook
Labels: excel trim spaces formula
Older Posts Home
Subscribe to: Posts (Atom)
www.cineclouds.com. Powered by Blogger.

Popular Posts

  • Yesterday's Date Function in Excel
  • Using Tomorrow date function in Excel
  • PI circumference formula
  • Previous month date function in Excel
  • One week ago date function in Excel
  • Convert Number to Words (Indian Format)
  • SIN, COS and TAN Formulas
  • Year function
  • Date
  • Removing spaces

Blog Archive

  • ▼  2021 (8)
    • ▼  June (2)
      • Remove Duplicates
      • WEEKNUM
    • ►  April (1)
    • ►  March (5)
  • ►  2015 (4)
    • ►  December (1)
    • ►  April (1)
    • ►  January (2)
  • ►  2014 (13)
    • ►  November (2)
    • ►  October (1)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  April (2)
    • ►  March (3)
    • ►  January (1)
  • ►  2013 (40)
    • ►  December (2)
    • ►  October (6)
    • ►  April (4)
    • ►  March (1)
    • ►  February (11)
    • ►  January (16)
  • ►  2012 (38)
    • ►  December (3)
    • ►  November (12)
    • ►  October (22)
    • ►  July (1)
 

Copyright © 2011 Internet Education | All Rights Reserved | Powered by Blogger | Designed Template by Ematoh