Dose for Excel ribbon
“Editing” utilities » Remove Spaces

In the Excel menu choose: DOSE EDITING » Editing » Remove Spaces

  1. Leading (_A).
  2. Trailing (A_).
  3. Extra (__A___B____).
  4. All.




 
1. Leading (_A)

Save time removing leading spaces (spaces at the begining of cell value) from cells values.
 
2. Trailing (A_)

Save time removing trailing spaces (spaces at the end of cell value) from cells values.
 
3. Extra (__A___B_____)

Save time removing extra spaces (convert 2 or more spaces into 1 space).
 
4. All

Save time removing all spaces from cell values whether leading or trailing or extra spaces.
Excel leading spaces
Excel trailing spaces
Excel extra spaces
Excel all spaces
Excel spaces
Up
Excel leading spaces
Excel leading spaces
Excel trailing spaces
Excel trailing spaces
Up
Excel extra spaces
Excel extra spaces
Up
Up
Excel all spaces
Excel all spaces
Home

Copyright © 2014 - 2017 Zbrainsoft.com | All Rights Reserved. Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Home