make all your text a monospaced font like courier new and set your column
widths to the proper spacing. Then save as a space delimited file (fixed
width).

Or you could write code to loop through you cells and build the proper
output strings.

http://support.microsoft.com/support...eio/fileio.asp
File Access with Visual Basic® for Applications

Regards,
Tom Ogilvy


"AJ" wrote in message
...
How can we convert excel sheet into text format?
In that i need to put everything at a specific space.
like it is specified that column should appear in text
from 1-6 spaces and then column 2 should appear from 11-13
spaces
Thanks
AJ