Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Field length of VBA totals in Excel 2003 | Excel Discussion (Misc queries) | |||
Export file to CSV delimited with fixed field length | Excel Discussion (Misc queries) | |||
How do I fix a field length? | Excel Discussion (Misc queries) | |||
Pivot Tables..I give up... | Excel Worksheet Functions |