Google Them Google Tips and Tricks

Miscellaneous Tips:

—
Using Open Office Spreadsheet to parse commas in one field to split into separate fields:
Data->Text to Columns->select “Comma” (make sure you’ve selected the columns or fields you want to parse)
—