Click Data > Text to Columns to open the window shown in shot below.

For example, if there was an address column in the spreadsheet you could select that to split it down into smaller parts.

Open a spreadsheet and then select a column, or group of cells in a column, to split. With that you can cut your spreadsheet columns down to size. As such, Calc has a Text to Columns option for splitting columns. In other words, I'd expect that you can type the formulas in the first row of your OpenOffice Calc sheet and copy them down to the rest of the row, and things will just work.Sometimes Calc users might need to split data in one column into another. this probably isn't important to you yet). ($C1 and C$1 are alternates that allow one parameter of the address to change in the usual relative sense while fixing the other half in place. To force a formula to use an absolute reference, one specifies the cell address with a dollar sign - $C$1 will always point to (use) the contents of cell C1, regardless of where the formula ends up. So when that formula is filled into other cells (either by Fill Down, or dragging the little handle in the corner of the cell outline, or by copy-pasting the formula into a range of selected cells) the new formulas are similarly treated, by default, as referring to the cell that is one column back from them, in the same row. In Excel, a formula in cell D1, that points to a cell in C1, is treated as a relative reference - that is, one column back from where I am now. I don't have OpenOffice in front of me, but it tries really hard to be Excel like in many ways, so usually assumptions about Calc based on Excel are fairly close to reality.

Openoffice columns only on part of page