A horse's olfactory systems never rest. He is analyzing smells every second of the day--barn smells and herd smells, water smells, plant smells, and the smells of the humans, dogs, and cats that enter his environment every day.
1 Select the text you want to hide or the hidden text. 2  Click the Home tab, and then click the Font Dialog Box Launcher. 3  Click the Font tab. 4  Select or clear the Hidden check box.ide or Unhide Text. 1  Select the text you want to hide or the hidden text. 2  Click the Home tab, and then click the Font Dialog Box Launcher. 3  Click the Font tab. 4  Select or clear the Hidden check box. 5  Click OK.
For the purposes of this demonstration, weâve called the column âTrim.â. To follow using our example above, download Excel Remove Spaces Formula Template 1.xlsx. Next, click in the first cell of the Trim column. On the Formulas tab, click the Text dropdown menu in the Functions group and select TRIM.After the dialog box appears, click on the cell that contains the text you would like to remove spaces from to complete the function. Click OK.opy the formula to the remaining cells in the helper column. Then copy the data to the data column as you did before using CTRL-C and Paste Options. Bonus Hint! You can also remove spaces using the Find/Replace feature in Excel. Click CTRL+F to open the Find dialog box, then click the Replace tab.