Actually, that is the real potential of this function. You can use the Trim function in combination with other functions or formulas. The above TRIM formula will remove the extra spaces in the provided text. Text – The text (see the formula below) or reference to a cell containing the text to be trimmed.Įxample 1: =trim("One Hundred Twenty Three Thousand Four Hundred Fifty Six Only") You can learn here how to use the TRIM Google Sheets function. Remove Additional, Double or Extra Spaces in Google SheetsĪs already told there are different methods for removing extra spaces in Google Sheets. Menu Command: Other than the formula-based approach, if your Sheets data contain extra spaces as part of a typo or the data imported from ecternal sources, then you can use the Find and Replace command (Ctrl+H) or the new Trim whitespace command in Sheets. The TRIM function can be used with other formulas to remove such extra spaces. In such cases, it’s a must to remove additional spaces from the formula outputs in Google Spreadsheets. The function we can use to remove additional spaces in Google Sheets data is called TRIM.įunction: Combination formulas can sometimes return extra spaces if any of the functions used in the combination returns a blank. You can remove additional, double or extra spaces in Google Sheets with either using a function or menu commands.
0 Comments
Leave a Reply. |