Highlight the cells containing the data you want to split
NOTE: Excel will split only one column at a time.

From the Data menu, select Text to Columns...
The Convert Text to Columns Wizard appears.

Select Delimited

Click NEXT

In the Delimiters section, select the character(s) you want to use to separate the cell data

OPTIONAL: Select or deselect Treat consecutive delimeters as one as appropriate (see Considerations)

Deselect any delimiters you do not want to use
The Data Preview box shows you what the split data will look like.

Click NEXT

OPTIONAL: If you do not want your split cells to write over the original cells, you may change the location where the split data will appear on the spreadsheet:

At the right end of the Destination box, click
The mouse pointer will become a cross.
Select the cell(s) where you want the split cells to appear
OR

In the Destination box, type the data destination in the format [ $(column letter)$(row number)]

To return to the Convert Text to Columns Wizard, click

Click FINISH
If there is any existing data in the cells where the split data will be placed, a dialog box appears asking if you want to replace the content of the destination cells.

To replace the data, click OK
To cancel the cell split and leave the cells as they were, click CANCEL

This makes life easier for me, I work with Excel sheets 90% of the time. I am still not a pro, but always have an Excel bible handy...