Hi, I have in column A a list of payroll numbers of different lenghts and also some starting with numeric and others with alpha letters. My problem is that the column with must be 7 digits long and if the payroll number is only 3 or 4 etc. I want a macro to fill up the front of the payroll number with spaces so that if it is saved as a text file all the payroll numbers will be in line to the left.