PDA

Click to See Complete Forum and Search --> : SendTo Excel Doesnt Recognise Commas [RESOLVED]


agmorgan
May 10th, 2004, 05:31 AM
My program outputs a comma delimited file which I subsequently analyse using Excel.
If I open the file from within Excel, the commas are recognised by the Text Import
Wizard and the data is input into cells.

However, if I open the file using my SendTo link to Excel, the file opens as text in one column.

Any ideas to this? How to fix it?

Lightning
May 10th, 2004, 07:44 AM
There is an option under the DATA menu, Text to columns (I don't know if it is excactly called like that, I have a dutch version from office at work), that does the trick

agmorgan
May 10th, 2004, 08:42 AM
Nice workaround :thumb:
I think thats the best Im going to get.

Thanks.