In column A, there are some alphanumeric entries. Somewhere in the alphanumeric entries (beginning, middle or end) there are the following:

1. Dates

2. Numbers (without decimals)

3. Numbers (with decimals)

Furthermore, there may or may not be spaces between numbers/dates and text entries. In Excel 2010 and prior versions, the only way to solve this problem would be write a formula or a VBA code. In Excel 2013, one can solve this problem by using the "Flash Fill" feature. Flash Fill is identifies patterns in your sample output data which you type (for a few entries) and suggests the output for the remaining cells of the range.

You may refer to my solution in this workbook.