Which state in the US has the largest population? Which US states have the largest Muslim populations? California, New York, Illinois, New Jersey, Indiana, Michigan, Virginia, Texas, Ohio, and Maryland have the largest Muslim populations in the country.
Select the cells containing the numbers. If you want to remove the dashes from the entire worksheet, click the Select All button, which is the rectangle between A and 1 in the upper left of the worksheet.To select an entire row or column, click on the number or letter pertaining to that row or column.n Excel 2003 or earlier, go to the Format menu and click Cells.. Go to the Number tab of the Format Cells dialog box. Select Number in the Category box. Change Decimal Places to 0 and click OK.. Open the Find and Replace dialog while the cells are still selected.
Removing these leading spaces â or trailing spaces that fall at the end of a cell's contents â requires an Excel function. Step 1. Click in the first cell of a blank column on your spreadsheet. Type an equal sign to signal Excel that the cell will contain a formula. Step 2. Type TRIM( â without quotation marks â and click on the location of the first cell in the column that contains data you want to clean up. Type a closing parenthesis to complete the formula. Press the Enter key. Related Reading: How to Count the Number of Non-Blank Cells in Excel.