software

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

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

=A1amp;REPT(quot;0quot;,8-LEN(A1))

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

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;MarkMquot; gt; wrote in message
...
gt;I have a spreadsheet with item numbers that range from 6-8 characters in
gt; length. What I want to try to accomplish is pad the end of those items
gt; numbers that are less than 8 chars. with 0's so they are 8 chars. long.
gt; So
gt; item # ME850C will pad out to ME850C00. Can I do this in Excel 2000?
gt;
gt; Thanks
Thank you for your help. That is exactly what I needed.

quot;Peo Sjoblomquot; wrote:

gt; You can use a help column, assume the example is in A1
gt;
gt; =A1amp;REPT(quot;0quot;,8-LEN(A1))
gt;
gt; copy down and paste special as values then paste over the old entries if
gt; needed
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;MarkMquot; gt; wrote in message
gt; ...
gt; gt;I have a spreadsheet with item numbers that range from 6-8 characters in
gt; gt; length. What I want to try to accomplish is pad the end of those items
gt; gt; numbers that are less than 8 chars. with 0's so they are 8 chars. long.
gt; gt; So
gt; gt; item # ME850C will pad out to ME850C00. Can I do this in Excel 2000?
gt; gt;
gt; gt; Thanks
gt;
gt;
gt;