tabvur.blogg.se

Press Enter and the data from cell A2 is displayed without the extra spaces. For example, the formula would look like =TRIM(A2.Įnter a right parenthesis ) to the end of the formula in the trim cell to complete the formula. This action enters the cell data in the trim cell. This action enters the formula in the blank cell and appears as =TRIM(.Ĭlick the cell containing the data with the extra space, eg., cell A2. In the auto-suggest terms that pop up when you start typing the formula, double click the =trim option. In the trim column, type =trim in the first cell next to the cell of data from which you need to remove spaces. How to add or remove a cell, column, or row in Excel. In the top cell of the new column, enter a label for the column, like “Trim” or similar. Open the Microsoft Excel workbook containing the data you need to edit.Īdd a column to the right of the column containing cells with spaces. Steps for removing extra spaces with the Excel trim function #

Leave the Replace with text field empty.This action places a space in the text field. Click in the Find what text field, and press spacebar once.On the keyboard, press Ctrl+H to bring up the Find and Replace tool.Select the cells that contain extra spaces.Open the Microsoft Excel workbook containing the data you need to edit.Steps for removing spaces in cells containing only one word # Below are steps for removing the extra, unnecessary spaces using two different methods. Occasionally, you may find one or more extra spaces in a cell in Microsoft Excel.