How to Remove Extra Spaces in Your Google Sheets Data – Guide

Google Sheets is a powerful and free spreadsheet tool. Many individuals, organizations, and businesses find Google Sheets an invaluable addition to their productivity toolset. While not as powerful as paid programs like Excel, Sheets does offer a wide variety of features with a smooth learning curve. You can remove extra spaces in Google Sheets data with a function or menu commands. The function we can use to remove extra spaces in Google Sheets data is called TRIM. On a computer, a space between words is not an empty space but a character and these extra characters can affect how data is used in a worksheet, for example in the CONCATENATE function which combines multiple data cells into one. ..

Remove extra spaces from formulas in Google Sheets There are several ways to remove spaces from a Google Sheets spreadsheet, including built-in functions and a useful add-on. Each of these methods is effective, but some are better suited for certain situations. Check out the options below and choose the one that best suits your needs.

Google Spreadsheets TRIM Function

TRIM(string) The TRIM function truncates the string to the length specified by the string argument.

TRIM(text)

The TRIM function removes unnecessary data from a string. This can be helpful if you want to keep your string as short as possible. ..

This is the data you want to remove spaces from. This can be: Remove spaces from data.

The data that needs to be cut from the government’s budget.

The cell reference to the location of the text data on the worksheet.

Removing the original data with special paste

If the cell reference to the location of the data to be trimmed is used as a text argument, the function cannot reside in the same cell as the original data. As a result, the affected text must remain in its original location on the worksheet. This can present problems if there is a large amount of trimmed data or if the original data is located in an important work area.

One way to work around this problem is to use Paste Special to paste values ​​only after the data has been copied. This means that the results of the TRIM function can be pasted back over the original data and then the TRIM function removed. ..

How to Remove original data with special paste

To remove the trimming data from cells A1 to A3, use the Paste Special Paste Values ​​option. Then use the TRIM functions in cells A6 to A8 to remove the trimming data.

Cell A6: The worksheet has a column for each day of the week. Cell A7: The worksheet has a column for each hour of the day. Cell A8: The worksheet has a column for each minute of the hour. ..

The three cells in this row are copied.

To paste only the results of the TRIM function into cells A1 through A3, select Edit > Paste Special > Paste Values ​​Only. ..

All cells must have trimmed text. ..

Cell A6: The worksheet has a column for each day of the week. Cell A7: The worksheet has a column for each hour of the day. Cell A8: The worksheet has a column for each minute of the hour. ..

Delete all three TRIM functions on the keyboard.

After functions are deleted, trimmed data should still be present in cells A1 to A3.

Final note

Google Sheets is a great tool for tracking data. However, if you have a lot of data, it can be difficult to keep track of where each row and column goes. To make life easier, you can use Google Sheets’ extra spaces feature to help you keep track of your data. To use the extra spaces feature, first open Google Sheets and click on the three lines in the top left corner of the screen. Then select the row or column that you want to add an extra space to. After clicking on the row or column, a new line will appear in the top left corner of your sheet with a number next to it. This number will tell you how many extra spaces are needed for that particular row or column. For example, if you want to add an extra space at the bottom of your sheet for Row 1 (the first row), then you would type “1” into the number field and click on OK. If you only wanted to add one space at a time, then type “0” into the number field and click on OK. You can also drag and drop cells onto your sheet to change their positions. Once you have added all of your cells, click on OK in order to finish adding space information to your sheet. Now that your sheet has been updated with new space information, you can use it as normal!