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.
If you also need to remove line breaks from cells, you can add the CLEAN function like so: =TRIM(CLEAN(text)) The CLEAN function removes a range of non-printing characters, including line breaks, and returns cleaned text. The TRIM function then takes over to remove extra spaces and returns the final text. Note that CLEAN is not able to remove all non-printing characters, notably a non-breaking space, which can be appear in Excel as CHAR(160). By adding the SUBSTITUTE function to the formula, you can remove specific characters.