How to Remove Spaces in Excel
In this tutorial, I will show you two ways to remove spaces in Excel. 1. Using TRIM function. 2. Using Find and Replace. #1 Using TRIM Function excelentp.blogspot.in Excel TRIM function removes the leading and trailing spaces, and double spaces between text strings. For example, in the above example, to remove spaces from the entire list if first names (in A2:A7), use the following formula in cell C1 and drag it down for all the first names: =TRIM(A2) Excel TRIM function would instantly remove all the leading and trailing spaces in the cell. Once you have the cleaned data, copy it paste it as values in place of the original Data. This function is also helpful if you have more than one space character between words.It would remove the extra spaces such that the result always have one space character between words. Excel TRIM function does a good job in removing spaces in Excel, however, it fails when you have non-printing characters (such as...