Title: Learn How to Remove Extra Spaces From Excel Using TRIM
Headings: How to Remove Extra Spaces From Excel
How to Remove Extra Spaces From Excel
An easier way to clean up your Excel spreadsheet
How the TRIM Function Works
Using the TRIM Function
Removing Extra Spaces From an Entire Column
Using the Search and Replace Short Cut Key
Was this page helpful?

Content: Instead, click the down arrow under Paste on the Home ribbon, then select Paste Values. Removing Extra Spaces From an Entire Column
The method above works well if you're only cleaning spaces from one cell, but what if you want to remove spaces from an entire column? The procedure for dealing with a column isn't that different from dealing with one cell. In this example, the column with too many spaces starts with A2. Create a new empty column beside the column you want to remove spaces from (in this example this new column starts with B2). Click on the top empty cell in your new column (B2). Type =TRIM (B2) and press Enter. Hold down the Shift key, and hover your mouse at the bottom of cell B2 until the cursor changes to two horizontal lines with an arrow above and below them. ( This feature isn't available in Excel Online; you'll have to use the Fill Handle to copy the formula.)