Hi

I have a database in excel which holds information for a label program
to import & produce barcodes.

My problem is i need to have each cell to have the same amount of
charecters to keep consistency in the barcode image size, say 10
charecters.

So if i have a label holding the following infomation, ABCDEFG i need
to add 3 spaces to equal the 10 charecters.

Is it poosible to write a macro that counts the charecters and then
add the required amount of spaces to equal 10 charecters.

Thanks

Add