Spaces can make your dataset untidy. Finding and cleaning large blank spaces may be tedious if you are working on a large dataset. These large blank spaces can alter your document's column width. To ease users from all these downfalls, Excel has numerous ways and tools that can be used to fix large blank spaces. This post will guide the user on how to fix the problems of the blank space.
Using the TRIM Function to Fix large Blank Spaces
A] Using the Formula bar
Here are the steps to follow:
1. Open the Excel application.
2. Open the Workbook that contains your dataset.
3. Click on an empty cell that will hold the results, and then click on the Formula bar.
4. Type the Equal sign followed by the TRIM function. That is, =TRIM (
5. Select the cells with your argument (text string). For Example, =TRIM (A1)
6. Finally, hit the Enter key. That is all you need to do.
B] Using the Insert Function Tool
Steps to follow:
1. Open the Excel application.
2. Open the Workbook that contains your dataset.
3. Click on the Formulas tab on the screen, and then locate the Function Library section.
4. Click the Insert Function button to open the Insert Function dialogue box.
5. In the Search for a Function section, type TRIM, and press the Go button.
6. Select the TRIM option in the Select a Function section and then hit the Ok button.
7. In the Text section, click on the button on the right side, and select the cell that contains the string you want to clean.
8. Finally, click the OK button. That is all you need to do.
C] Using the Text Tool
Steps to follow:
1. Open the Excel application.
2. Open the Workbook that contains your dataset.
3. Click on the Formulas tab on the screen, and then locate the Function Library section.
4. Click the TEXT drop-down button. From the menu, click the TRIM option.
5. In the Text section, click on the button on the right side and select the cell that contains the string you want to fix large blanks.
6. Finally, click the OK button. That is all you need to do.
Using Find and Replace Tool
Steps:
1. Open the Excel application.
2. Highlight the cells with the dataset you need to find and fix spaces.
3. Click on the Home tab on the ribbon, and locate the Editing section.
4. In the Editing section, click the Find & Select drop-down button and select the Replace option.
5. Click on the Replace tab in the Find and Replace dialogue box. Press the Space Bar twice in the Find What section, and press the Space Bar once in the Replace with Section.
6. Click the Replace All button to find and fix all large blank spaces in the selected sheet.