![]() A dialog window pops up informing you that Excel has made some replacements. To remove spacing from the selected cell, press Space twice in the Find what text box. Usually, you would enter text to replace in the Find what box and then input the replacement in Replace with. Select B3 and press the Ctrl + H hotkey to open the Find and Replace window shown directly below. The advantage Find and Replace tool is that you can remove the spaces directly from the cells without adding extra spreadsheet columns for functions.įirst, input the numbers ‘ 435 789 ‘ in cell B3 with two leading and two trailing spaces plus three spaces between the values. You can also delete leading, trailing and excess spacing between text within a range of selected cells with the tool. ![]() ![]() Find and Replace is a tool that’s similar to the SUBSTITUTE function. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |