If you have some text in cell A1 from which you want to remove spaces, use the below formula: =TRIM(CLEAN(A1)) To remove non-printing characters, you can use a combination of TRIM and CLEAN functions. It would remove the extra spaces such that the result always have one space character between words.Įxcel TRIM function does a good job in removing spaces in Excel, however, it fails when you have non-printing characters (such as line breaks) in your data set. This function is also helpful if you have more than one space character between words. Once you have the cleaned data, copy it paste it as values in place of the original data. ![]() In this tutorial, I will show you two ways to remove spaces in Excel.Įxcel TRIM function removes the leading and trailing spaces, and double spaces between text strings.įor 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)Įxcel TRIM function would instantly remove all the leading and trailing spaces in the cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |