length of spaces

R

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?
 
D

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.
 
Top