How To Remove Leading Spaces In Excel

Only excel vba has the option of ltrim and rtrim functions which will either remove all the spaces from the left side leading or from the right side trailing.

How to remove leading spaces in excel. If you need to strip leading and trailing spaces from text in one or more cells you can use the trim function. Select the cells range entire column or row where you want to delete extra spaces. Remove spaces in excel using trim function the fast and easy way to remove spaces in excel is using the trim function.

Remove leading and trailing spaces. Trim a2 and copy and paste the formula to the remaining cells using the shortcut ctrl d or dragging it down from the right bottom of the formula cell upto the required cell. The trim function removes all the spaces except the single space after each word.

Consider the below table with different type of spaces between a and b. Let s apply the trim formula in excel to remove all kinds of spaces in a cell. 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.

As you can all the leading and trailing spaces are removed with single space from the text. This trim function removed the spaces between capital and is. As of now currently there is no excel formula to remove specifically or only leading or trailing spaces by keeping multiple spaces between words intact.

Trim b3 once you ve removed extra spaces you can copy the cells with formulas and paste special elsewhere as values to get the final text. Use vba code to remove leading spaces only 1. You must have faced a condition when your data cells contain extra spaces leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data.

B2 is the cell you want to remove spaces from see screenshot. In the example show the formula in cell c3 is. Press enter key to get the result then drag auto fill handle over the cells you want to remove extra spaces from all of leading spaces and trailing spaces and extra spaces have been removed.