For those of you that use OpenOffice like myself and others I know, the one feature that has always bugged me that was missing from Calc that was in Excel was the Text to Columns
I recently came across a macro that was created to provide this function. You can download it from: SourceForge
It is pretty easy to install.
1) download the zip file to your computer
2) Open Calc
3) Go to Tools|Package Manager
4) Press the Add button and browse to the zip file and press the Ok button
You might need to restart Calc
To use, just select the columns and use Tools|Add-ons|Text to Columns. This will start the Text to Columns wizard that is much like the one from Excel.