Hi, Joe-
To make sure I understand: column A contains either a completely
numeric entry or a mix of alpha / numerics, but not both in the same
cell. Correct?

If yes, you try this process to create two separate worksheets:
1. Make a backup copy of your data! Don't risk a catastrophic loss of
data. Try this process on the BACKUP copy to make sure it works; if
you like the results then move forward from there; if not you can
revert to the saved copy.
2. Insert a "helper" column, and number each row using the Fill Series
function in Excel. This will allow you to sort the data back into its
current order. Let's assume your helper column is column A; your
numeric / alpha-numeric entries are now column B.
3. Sort the spreadsheet on column B. This will separate all the
numeric entries from the alpha-numeric entries.
4. Make a copy of this spreadsheet: right-click on the tab name,
select Move or Copy, click the Create Copy box, and choose a relative
location in the workbook for the new tab.
5. On the tab that will hold only numeric entries, delete the
alpha-numeric entries.
6. On the tab that will hold only alpha-numeric entries, delete the
numeric entries.
7. Sort each spreadsheet on the "helper" column, then delete the
helper column.

The data is now separated and back in its original order.