Excel - 2003 - save a spreadsheet in a fixed column text format

[BRIANH]

Try as I might, I can't seem to find a solution to my issue.  I have a spreadsheet and would like to save the spreadsheet date
as text and have the data output as a fixed column width with no delimiters (like an implied table) . I've tried altering each column in the spreadsheet using data, text to columns..No luck. When I copy and paste the data into a txt doc. the data remains as delimited.
The original input to the spreadsheet is in delimited format.

Anyone have any ideas for this? 
Thanks

[Salmon Trout]

You can use Save As and choose "Text (MS-DOS) .txt" but you still have delimiters. I think you'd need a VBA macro such as the one in the spreadsheet on this page linked to here:

http://www.databison.com/index.php/export-excel-as-fixed-width-text-file-format-using-vba/

But I would prefer the time-honoured method of installing, as an additional printer, the "generic/text-only" printer and then, from the Excel print menu, choosing (1) that printer (2) checking the "Print to file" box, and (3) supplying a file name.

The output will be a non-delimited text file. You may still have to do a bit of editing (e.g. in Notepad) but it gets you nearly there.

Code: [Select]

First Name   Surname   Date of birth Sex       Start Date
 John         Smith     01/01/1990    Male      02/02/2010
 Mary         Jones     02/02/1985    Female    05/05/2005
 Howard       Wilson    03/09/1980    Male      06/10/2001

[BRIANH]

Thanks for the tips and suggestions.. I've not had experience with setting up a macro in EXCEL and thought I'd try the 'install a generic printer' option. It seemed to work for me, some editing but at the endo of the day.. I have a fixed width column report..

thanks

[Salmon Trout]

That spreadsheet I linked to is a ready made one that you can just use. Try it out.