Pad field length
 

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 0s so they are 8 chars. long. So
item # ME850C will pad out to ME850C00. Can I do this in Excel 2000?

Thanks

Pad field length
 

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



"MarkM" wrote in message
...
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

Pad field length
 

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

"Peo Sjoblom" wrote:

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



"MarkM" wrote in message
...
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