| View previous topic :: View next topic |
| Author |
Message |
nmccann
Newbie
Joined: 12 Apr 2012
Posts: 1
Location: Bunmahon, Ireland
|
 Posted: Thu Apr 12, 2012 4:29 am Post subject: Help with csv file |
 |
|
I have a csv spreadsheet with 3000 + lines of data. I need to create new rows down trough the data. the new rows are to split existing text over new rows. Using replace I have tried placing \n at the required break point in the cells but this has not worked, any suggestions.
Moderation probe1: moved to CALC section, where this question seems to belong to; CODE SNIPPETS is for working code examples only; edited subject |
|
| Back to top |
|
 |
DiGro
Super User
Joined: 02 Jun 2004
Posts: 1208
Location: Hoorn NH, The Netherlands
|
| Posted: Fri Apr 13, 2012 8:29 am Post subject: |
|
|
You'd beter off in a texteditor then in a spreadsheet.
Splitting CSV is easier done in texteditors like Notepad++, Notepad or even Writer. then in Calc.
In calc it requires selecting, copying/extracting from old cells and pasting in new cells.
It's probably easier to first edit the CSV-file and then import it into Calc.
If you persist on a spreadsheet
_________________
DiGro
Windows 7 Home Premium and OOo 3.3 NL (Dutch) |
|
| Back to top |
|
|
|
