length of spaces

[Rusty]

in a comma delimited file, how can I set the number of
spaces to 100 exactly. I can have no more and no less
than 100 spaces for the information in the file.
how can I make sure of this?

 

[Dave Peterson]

Do you really mean a fixed width file (instead of comma delimited)? If yes,
then here's a link that may help. It provides a worksheet formula that
concatenates strings with spaces and provides a macro approach.

 

[Dave Peterson]

doh!

http://groups.google.com/[email protected]