Title: Remove Leading and Trailing Spaces - Free Excel Tutorial
Headings: Remove Leading and Trailing Spaces
Remove Leading and Trailing Spaces
Method 1: Remove Leading and Trailing spaces with Excel Formula
Method 2: Remove Leading and Trailing spaces with Excel VBA macro
Related Functions

Content: Remove Leading and Trailing Spaces - Free Excel Tutorial
Remove Leading and Trailing Spaces
scott @ March 12, 2018 Excel Basics, Excel Examples
In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a column. If you remove leading spaces in cells one by one by manually, it will waste a lot of time. So this post will show you two methods to quickly remove leading and trailing spaces from text in one or more cells in your worksheet. Assuming that you need to remove all leading spaces and trailing spaces in the range of cells A1: A4, you can refer to the following two methods to achieve it. Method 1: Remove Leading and Trailing spaces with Excel Formula
To remove leading and trailing spaces from text string in Cells, you can use the TRIM function to remove extra spaces. So you can type the following formula in Cell B1, then press Enter key. = TRIM (A1)
Then select Cell B1 and drag the AutoFill Handle down to other cells that you want to remove the leading or trailing spaces.