Pad field length

[Guest]

I have a spreadsheet with item numbers that range from 6-8 characters in
length. What I want to try to accomplish is pad the end of those items
numbers that are less than 8 chars. with 0’s so they are 8 chars. long. So
item # ME850C will pad out to ME850C00. Can I do this in Excel 2000?

Thanks

 

[Peo Sjoblom]

You can use a help column, assume the example is in A1

=A1&REPT("0",8-LEN(A1))

copy down and paste special as values then paste over the old entries if
needed


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

Thank you for your help. That is exactly what I needed.