Jake Trent

Split Text in Open Office Spreadsheet

Sometimes I paste text into a spreadsheet so that I can quickly manipulate it. The same could be done with a small script, but this particular feature is built into Open Office Spreadsheet: You can split text into separate columns using delimiters.

If I had text like this:

1. The Morning Breaks
2. The Spirit of God
3. Now Let Us Rejoice
4. Truth Eternal
5. High On A Mountain Top

I would paste it into one column in the spreadsheet, select that column, and select Date -> Text to Columns… In that dialog, you can select what you want to use as your delimiter. I my case, I chose the period (“.”). That way, the hymn # ends up in column 1, the hymn title in column 2. The same feature is available in MS Excel.

<a href="https://picasaweb.google.com/lh/photo/FUo5j2r8EbPsCGwvHQQgGA?feat=embedwebsite"><img src="https//lh3.ggpht.com/_5XZCKcD6--c/Spbuc8alHvI/AAAAAAAAISg/SrQ9iopLEx4/s400/texttocolumn.png" /></a>