30+ How To Remove Extra Space In Excel Cell Pictures. Here we discuss how to remove spaces from text & numbers using trim, delimited where trim function did not remove the spaces between the texts but with text to columns we can remove the extra spaces between the texts and numbers in excel also. The tutorial explains how to remove blank spaces in excel using formulas and the text toolkit tool.

It happens sometimes that you get trailing and leading spaces in your data and it there are total 70 characters in the cell and when you have used trim, characters count is decreased to 41, that means it has deleted the 29 spaces.

This post shows you how to remove leading spaces (at the start of the text) and trailing spaces (at the end of the text) in excel. To get the length of a string, use the len function. Some people get a little overexcited with the space bar when entering data. The image below shows the contents that we have copied from other sources.