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.
Select the Empty Cells. To select the empty cells, use Excel's built in Go To Special feature: 1  Select columns A and B, that contain the blank cells. 2  On the Ribbon's Home tab, click Find & Select. 3  Click Go To Special.4  In the Go To Special dialog box, click Blanks, then click OK.elect the Empty Cells. To select the empty cells, use Excel's built in Go To Special feature: 1  Select columns A and B, that contain the blank cells. 2  On the Ribbon's Home tab, click Find & Select. 3  Click Go To Special.