Hi Robert, Robert Volke wrote: >I downloaded the newer Text To Column macro off of >http://www.ooomacros.org/user.php that says its supposed to be able >to split columns in Calc by fixed width in addition to other delimiters,
It's not "supposed" to do, it *really* does it! :-) Are you sure to have the latest version? Check the version from the menu Help (?) -> "About Text To Columns..." (in Calc) In the about dialog you should read: "TextToColumns 2005-04-19" However, the link for the latest version is: http://prdownloads.sourceforge.net/ooomacros/TextToColumns.uno2005-04-19.zip To avoid possible problems I suggest to remove any previous versions TextToColumns is deployed as UNO package, so you don't need to unzip the file before installing. In ooo2.0 use the package manager in order to install the macro menu Tools->Package manager... In ooo 1.1.x you must use pkgchk from the command line: $<OOoInstallPath>/program/pkgchk -v TextToColumns.uno2005-04-19.zip (stop any running OOo instance before, even the quickstarter) >but I tried using it and although it will split by other delimiters, it >will not split by fixed width. In the TextToColumns dialog (en-US localization): -> Select the radio-button "Fixed lenght fields" -> Click in the preview area to add or remove column separators -> Be happy :-) >Does anyone know of a working Text To >Column macro that will split by all of these delimiters (not all at once >of course). This is a screenshot (not from Excel...) that should illustrate what I've just said http://www.paolo-mantovani.org/images/ttc_screenshot1.png ciao Paolo --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
