make cell length always equal 10
Hello Little Pete,
i guess i am confused
u have a PLANT with PARTS
u also have a list in column of PARTS with its particular serial number
then u need to build a Plant Number
to build the plant number i am copying the serial number in from another column.
or u like to build another serial names like "PLANTnPARTS" with something
like;
PLANT ID_SERIAL NUMBER OF PART
or
PLANT ID_{first 10 characters only) (add 0's if serial number<10 characters)
then try...
="yourPLANT ID-" & "LEFT(C1&REPT("0",10),10)"
where column C assume to contain the original serial numbers of each part.
adjust to suit your plant...
--
*****
birds of the same feather flock together..
"Little Pete" wrote:
hi,
i have a serial number used as part of a plant number, this section has to
be 10 digits in lenght. to build the plant number i am copying the serial
number in from another column. when the serial number is 10 everything is ok
but when it is to short i need the system to fill it up with 0 at the end or
when it is to long i need the system to take only the first 10.
thanks for the help!
|