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

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

--
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