OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Adding a new line in Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
DaveStephenson
Newbie
Newbie


Joined: 03 Feb 2005
Posts: 1

PostPosted: Thu Feb 03, 2005 8:12 pm    Post subject: Adding a new line in Calc Reply with quote

I have csv files that contain "" to represent a new line. Once I load these files into Calc, how can I change this to an actual new line? I can manually go in and type Ctrl-Enter, but I can't figure out any find & replace way to do this. I can use regular expressions in Writer to replace with \n and it works, but this just puts "\n" in its place in Calc. Any thoughts?
_________________
Dave Stephenson
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Fri Feb 04, 2005 4:23 am    Post subject: Reply with quote

Can I recommend freeware http://liquidninja.com/metapad/
The FIND and Replace allows you to do many different things including replacing tabs new lines and more., to create a CSV you must SAVE AS and give the file a .csv tag
then open in Calc using tab or comma or whatever you prefer.
I also use metapad as a quick notebook that stays stuck to the glass on top of ALL other programmes
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group