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]