HELP

Have an excel sheet with 6 columns and 100 rows. I am trying to save as or export this data with no spaces/tabs into a plain text file with one row per line. No matter what i try it always has spaces or runs two rows on one text line. Is there a macro or a way I can do this by just saving the file?

Any help would be greatly appreciates - Excel 2000/Win 2000

thanks kevin