length of spaces

  • Thread starter Thread starter Rusty
  • Start date Start date
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?
 
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.
 
Back
Top