Re: [libreoffice-users] How to import a txt file into an existing Calc sheet?

On 7/27/2011 1:01 PM, JOE Conner wrote:
> On 7/27/2011 5:04 AM, David B Teague sr wrote:
> > Using your data, I used
> > Edit > "paste special"
> > then chose "unformatted text" from the dialog.  The dialog then 
> > wanted to know what the separator was. I tried "space" and it 
> > inserted data into cells but your data has a number spaces so I got 
> > many blank cells.
> >
> > I tried to replace multiple spaces with a comma, and that worked, but 
> > your data doesn't have a consistent number of separating spaces so 
> > that did not appear to be useful. I played with it, and I believe if 
> > you separate the data items with a single space, a tab, or something 
> > that Calc likes for a separator you may have some luck with "paste 
> > special".
> >
> > Hope this helps.
> >
> > --David Teague
> Did you not have the checkbox checked for "merge delimiters"?
> Joe Conner, Poulsbo, WA USA
As I said, I did not, and had not seen the message on this that suggests 
that ... but I just tried it-- it works like a charm. Thanks.
--David

--
nil significat nisi oscillat



--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted