Title: How to Remove Leading Blank Spaces in Excel | Small Business - Chron.com
Headings: How to Remove Leading Blank Spaces in Excel
How to Remove Leading Blank Spaces in Excel
1
2
3
4
5

Content: 2
Type "TRIM (" – without quotation marks – and click on the location of the first cell in the column that contains data you want to clean up. Type a closing parenthesis to complete the formula. Press the "Enter" key. 3
Click on the bottom-right corner of the cell into which you typed your formula. When your cursor changes to a black plus sign, click and drag downward until you reach and fill the cell in the same row as the last value in the column of data you're tidying up. 4
Click on the header of the column to select the calculated values that result from your TRIM function. Press "Ctrl-C" to copy the data. 5
Click on the header of the column that contains the data you just cleaned up. Click on the Home tab of the Excel Ribbon and locate its Clipboard group. Click on the arrow below "Paste" and choose "Paste Special."