Inputting variable length data - outputting fixed character result

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixed Length, Text Formatted 2
Fixed Character (alpha) length 5
Fixed Length 9
Does Access store data in fixed lenght or variable length format 2
Character Length with Fixed Length Imports 1
Adding "fixed" data to variable length data 3
split text in one cell into multiple cells without breaking the wo 3
how to split a string using ,fixed character length, variable text delimmiter 24

Top