Bob wrote:

That helped, thanks.

You're welcome!


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?

It will do that in the process of importing a text file like a csv. A dialog will come up that allows you to specify the field delimiter, text delimiter, or fixed column lengths. The Text-to-column macro seems to use the same dialog.


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

Just select the column you want to parse and go to Tools -> Add-Ons -> Text to Columns.

If you're wanting to do something more complex, like extract the city, state, and zip code from a field that looks like "Phillipsburg, KS 67661", then you will need to play with the text functions, left(), right(), mid(), find(), etc.

--

Rod

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to