Text to Columns can be very useful.  If you inherit a worksheet that contains two or more pieces of data that appear in one column, you can separate the data into individual columns.  This will work in Excel 2007 & Excel 2010.