Very often, data that is imported into Excel needs to be formatted. You may find that when importing numbers, Excel will import your data as a text format – and often with spaces before the data. Converting the text to a number format using the Format Cells command will not clear the spaces – they will remain.
One way to remove any leading spaces from data in a cell is to use the Value and Trim function. For instance, if I wanted to remove the spaces from cell A4, the formula would be:
=VALUE(TRIM(A4))
If your goal is to remove the spaces AND convert the text data to number format, select the cells that contain the data, click the Smart Tag button and choose “Convert to Number”.
Similar Posts:
- Using the Convert Function in Excel
- Counting Cells with Values in Excel
- Counting Blank Cells in Excel
- Counting Cells with Numbers and Text in Excel
- Using the PMT Function in Excel 2007
- Entering in Functions Manually in Excel
- Enter data in multiple cells in Excel 2007
