Excel How to Remove Trailing OR Leading OR Extra Spaces
Copyright © 2014 - 2023 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.
Remove Leading Or Trailing Or Extra Spaces From Excel Cells
You can remove leading spaces, trailing spaces, extra spaces or all spaces from selected cells in Excel easily with one click without writing any VBA code. Dose for Excel's Trim Spaces utility can implement this with one click on huge number of cells.
- Click DOSE » Text » Trim Spaces
- Usage:
1. Select a range of cells.
2. Check the option you need to remove leading, trailing, extra or all spaces.
3. Then click Apply. You will see the result as shown in the below screenshot.
Dose for Excel adds more than +100 new features and functions to your Excel.
Supported Excel versions: 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 14 days.
- Demo
