The new data are in sharp contrast to findings about drinking and driving among teens. The CDC reported last fall that alcohol use among teen drivers has decreased by 54 percent since 1991. Texting, however, has quickly grown in the last five to seven years, Adesman said.
The Trim function in Microsoft Excel can remove all spaces from text except for single spaces between words. Step 1: Enter the formula =TRIM (A1) in the adjacent cell C1 and press the Enter key. Step 2: Select cell C1 and drag the fill handle down to the range cell that you want to remove the leading space. Then you can see all cell content are extracted with all leading spaces removed.
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.