/
Removing Trailing Space from Cells in Excel

AGRIS Customer Documentation

Removing Trailing Space from Cells in Excel

How to remove the trailing space from cells in Excel that prevents formatting spreadsheet

  1. Click into the first cell. Notice there is a space after the data.

  2. Highlight the trailing space in the toolbar. This space represents a non-printable ASCII char 160 that needs removed to be able to format the cells as a number.

  1. Highlight the trailing space and copy it (use CTRL + C). This will copy the non-printable ASCII char 160 that cannot be seen.

  1. Once highlighted, choose find and select, then replace

  1. Paste the copied space character that cannot be seen into the “find what” box. Leave replace with blank. Choose replace all. This will then remove the space from all cells, and the cells can be formatted with Excel.

 

Written by S. Pykare 8/23/23

Related content

How to NOT print the ASCII Char(160) Trailing Space at the End of Character Fields
How to NOT print the ASCII Char(160) Trailing Space at the End of Character Fields
More like this
How to Remove the Trailing Space on Data Fields on Spreadsheets - Char160
How to Remove the Trailing Space on Data Fields on Spreadsheets - Char160
More like this
Moving Negative Sign from End of Number to Beginning in Excel
Moving Negative Sign from End of Number to Beginning in Excel
More like this
Exporting to Excel
More like this
Numeric Precision
More like this
Clear Lienholders from Name
Clear Lienholders from Name
More like this

3820 Mansell Road, Suite 350 ✦ Alpharetta, GA 30022 ✦ www.GreenstoneSystems.com
© 2011 - 2024 Cultura Technologies LLC. All Rights Reserved Worldwide.  Products and company names mentioned herein may be trademarks or registered trademarks of their respective owners.