On 4/8/2006 2:03 PM, Rod Engelsman wrote:
Bob wrote:
On 4/7/2006 Chuck wrote:
You could also try loading the file into a Calc spreadsheet and using
the "text to columns" add-on to split it up as you want. Then select the
text from the column and copy it.
You can get "text to columns" here...
http://sourceforge.net/project/showfiles.php?group_id=87718&package_id=104183
<- - - End of quote
This appeared yesterday under a different subject, and when I
downloaded the zipped file, there is no install file included, nor
were there any directions about how to install it under OOo Calc.
Can't seem to find anything on the web site to indicate how to do it,
either.
Could someone point me to a URL for TextToColumns installation
instructions?
Thanks.
The help isn't particularly clear on this IMO, but it is actually very
easy. Just go to Tools -> Package Manager... and in the dialog that
comes up, make sure that "My Packages" is highlighted in the box and
then click "Add". Finally all you have to do is point the file browser
to the zip file that you downloaded. There is no need to unzip the file
first. After that it is automagical.
That helped, thanks.
Now the problem is how to use it. Again, no help, and I can't find
anything at the sourceforge site. I assumed this macro would "parse" a
line of text from one column into separate columns. Perhaps I was wrong
about that.
Parsing text in a spreadsheet was a piece of cake in Lotus, which I used
for years. I'm having difficulty adjusting to the differences in OOo
Calc, so perhaps the ability to parse is already there, but I haven't
found it.
Questions:
(1) Does Calc already contain the ability to parse a line of text in a
column into multiple columns, i.e., citystatezip into city, state, zip?
(2) If not, does Text2Column accomplish that (based on the originally
quoted material, I think it does), and how is it used to do it?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]