Joined: 27 Apr 2005
|Posted: Wed Apr 27, 2005 7:52 pm Post subject: Text to Columns Macro
|I installed the text to columns macro (not the fixed width macro) and it doesn't work or I'm not doing something correct. As far as I know it is installed correctly.
The zip file comes with several folders. One is named "Text to Columns" This is the folder with the BASIC files to install from the Append option.
Problem is there are several macros to choose from for the "Text to Columns" macro itself. None of which seem to work for me.
Also, seems this should be an option under Data menu like in Excel. It is used quite a bit in audit accounting when taking accounting ledgers from a text delimited file and so forth and converting to Excel for work papers. I am aware of saving a file into CSV format and then opening Calc but it is not as convenient as the Excel built-in function.
Nevertheless, I would like to at least figure out what is going wrong with the "Text to Columns" macro.