Inputting variable length data - outputting fixed character result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
While it is possible to introduce leading zeros thru formatting, they may not
export. Instead, if your values are in column A starting in A1, then in B1
enter:

=REPT("0",26-LEN(A1)) & A1 and copy down. The correct number of leading
zeros will be supplied
 
Back
Top