How to clean data with MS Excel 2007?

When the list is in Excel, is it all in one column, or do you have 001 in say Col A, John Smith in Col B, the number in Col C etc or how is it laid out?