You can remove additional, double or extra spaces in Google Sheets with either using a function or a command. The function we can use to remove additional spaces in Google Sheet data is called TRIM. It’s a must to remove additional spaces from formulas in Google Spreadsheet. If your data contain extra spaces as part of a typo, you can use the Find and Replace command or Ctrl+H.
Remove Additional, Double or Extra Spaces in Google sheets
As already told there are two method in removing extra spaces in Google Sheets. Let’ start with the TRIM function.
Using TRIM function
=trim(“One Hundred Twenty Three Thousand Four Hundred Fifty Six Only”)
The above will remove extra spaces in the text in quotes.
Example 2: You can use trim function in combination with other functions or formulas.
In the above example I used trim function in conjunction with concatenate alternative formula.
Additional Reading: Combine Text and Date in Google Sheets
Using Find and Replace Command
This will not work in all cases. To remove extra spaces in Google Sheets using Find command, you should know the number of spaces to remove.
See the steps below.
Open the sheet you want to remove the extra spaces from text.
Do as follows.
When you click replace all it will find all the double spaces and replace with single space. This’s not applicable to functions. That means spaces that appear as a result of any formula will not be replaced with this command.
This way you can remove additional, double or extra spaces in Google sheets. There are more awesome Google Sheet tutorials covered in Info Inspired. Check this link. Also there are we have a quote section on this site to help to motivate you in your difficult times. Don’t forget to check that also Here.