Excel Tips, Tricks, and Shortcuts

In Excel spreadsheet, if you have typed some extra spaces between words. Therefore, you can use TRIM(text) function in order to get rid of those unwanted spaces. This function will erase all extra spaces but except for single spaces between them. In addition the formula =TRIM(text) function will remove leading and trailing spaces from the text as well. Syntax TRIM(text) How to use formula: To type: 1] =TRIM into any cell. 2] ( 3] Select the cell wanted to be trimmed. (See the image below as example by putting cell A1) 4] ) It's done. Text: the text in any cell from which you want spaces deleted. See an image example below for understanding easily. Did you find this article useful? See more another tips: VLOOKUP Searches For Value From Table Array In The First Column Return Value The Same Row Formula “LOOK UP - Array Form” Automatically Looks Approximate Match Values First Row/Column Formula “LOOK UP” For Using Approximate Match Values Sorted Ascen...