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: How to Remove Leading Blank Spaces in Excel | Small Business - Chron.com
How to Remove Leading Blank Spaces in Excel
Small Business
|
Accounting & Bookkeeping
|
Excel
By Elizabeth Mott
However carefully you monitor the data you enter and import into Microsoft Excel, and the output of formulas and functions that produce new values, it's easy to wind up with cells that contain one or more spaces as their first characters. You may see leading spaces like these in cells that hold the results of a process designed to split a first name from a last name in cells that contain both together. Removing these leading spaces – or trailing spaces that fall at the end of a cell's contents – requires an Excel function. 1
Click in the first cell of a blank column on your spreadsheet. Type an equal sign to signal Excel that the cell will contain a formula. 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.