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]

Reply via email to