Delete Unnecessary Spaces along with Line Breaks Read More: How to Remove Extra Spaces in Excel (4 Methods)ģ. So, when this window will appear, we can be certain of our operations to stop. To check if we can replace more double spaces with single spaces, we can press Replace All button once again and now a different message box will appear saying that the tool can’t find anything to replace. Rather, we have to apply the TRIM function here to remove all leading spaces here. But unfortunately, we cannot remove these leading spaces with this Find and Replace tool. If you look carefully at the text data, there are only leading spaces remaining. But don’t stop pressing the Replace All button right now.Īnd now probably we’ve reached our last occurrence of pressing the Replace All tab. Repeat the procedure and we’ll find that the lengths of our texts are decreasing which indicates that the texts are coming to a normal format with repeated steps. Let’s click on the Replace All button again and it’s now showing 12 more replacements have just been made. So, it means the number of unnecessary spaces is now decreasing gradually with the repetitions of the same procedure. And the message box tells us now that 33 replacements have been made which was 67 in the first application. Now we’ll find that more spaces have been removed from the data table. ➤ Keep the Find and Replace window open since the previous replacements were made. To remove these spaces, we have to repeat the procedure at a stretch. But if we now notice the data table, we’ll see that the texts have still different numbers of blank spaces among them. ➤ Tap Space only once in the Replace with box.Ī message box will pop up displaying the total number of replacements made in the worksheet. ➤ In the Find what box, press the Space button twice. ➤ Press CTRL+H to open the Find and Replace tool. Let’s apply this feature now to the texts with different numbers of spaces among them. In that case, we have to apply this feature again and again until the last replacement is made. If the texts contain a random or different number of spaces among them then this method is not suitable to remove all blank or white spaces. But with this method, we can remove only those spaces which are identical in the count. We can use Find & Replace tool from the Home tab to delete extra spaces. Apply Find & Replace Tool to Erase Extra Spaces in Excel Read More: How to Remove Spaces in Excel with Formula (5 Quick Ways)Ģ. After pressing Enter and auto-filling the rest of the cells in the Output column, we’ll get all texts in the same and exact format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |