Google Spreadsheets-Extract numeric values from cells
Many times you need to enter two different values into a cell sometimes both text and numbers. By default Google Spreadsheets aligns the numeric entry to the right and text entry to the left. But Spreadsheets will discard the numeric value and consider the whole input as a text value.