View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Webster Webster is offline
external usenet poster
 
Posts: 3
Default Inputting variable length data - outputting fixed character result

I'm opening a CSV file in excel and I need to reformat the data to input into
another software. The problem is that the output includes 1 column that must
be 26 characters in lenght (leading zeroes). The imported column will vary
from 3 to eight characters.

Is there a way to insert a variable amount of leading zeroes dependent upon
the length of the source?