How to Delete Trailing Spaces in Excel


Excel is an electronic spreadsheet program that can help you manage and analyze numerical data. Though you start an Excel spreadsheet by entering data in the cells of a table, you can manipulate that information with formulas, format it with color and fonts, and present it with charts that reveal numerical relationships in picture form. You can create your own functions or use built-in ones. For example, you can automatically delete trailing spaces that appear as extra blanks after text.

  • Click on the cell containing the text with the trailing spaces. Click the dropdown arrow by "Insert" in the "Cells" group of the "Home" tab. Choose "Insert Cells." You can also choose "Insert Sheet Row" or "Insert Sheet Columns" if text with trailing spaces extend across a full row or column. The Insert dialog box appears.

  • Select how to insert the blank cells. For example, if you want the blank cells to appear before the text cells, choose "Shift Cells Right." The cells move according to your choice.

  • Enter the following formula in the blank cell:


    In this formula, <cell> is the location of the text cell. For example, if the text cell is "A2," enter the formula "=TRIM(A2)" and press the "Enter" key. The text appears without trailing space in the cell where you entered the formula.


Promoted By Zergnet


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!