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.
Itâs easy to remove all whitespace from a string, but youâll typically want to keep a single space between words. Excel's Trim function will remove all but one space between words; however, it cannot remove non-breaking spaces â this requires a combination Excel's Substitute and Trim functions. Open your spreadsheet in Excel and locate the cells containing the whitespace that needs to be removed. Use the Trim function to remove whitespace created from normal spaces. The Trim function requires a single reference to operate. For example, entering =TRIM(A1) without quotes will strip all but single spaces between words from the string  this is a test  in cell A1, leaving this is a test.