Forum Discussion

krish86's avatar
krish86
Copper Contributor
Apr 09, 2019
Solved

FILL SERIES

HI,   I WANT TO FILL SERIES NUMBERS AS ATTACHED. PLEASE CAN YOU HELP ME OUT ON THIS.   04760000000000001 04760000000000001 04760000000000002 04760000000000002 04760000000000003 0476000000000...
excel
Formulas and Functions
  • Shivang_Sharma's avatar
    Shivang_Sharma
    Apr 09, 2019

    krish86 @vijay

     

    Hii Krish,

       I have solve your problem, the method which i have followed:-

    Fill a normal serie in A Column like as 1,1,2,2,3,3,4,4,5,5,6,6,7,7

    then put this formula =REPT(0,13-LEN(A1)) in B1 Because series is start A1,

    and again put this formula ="0476"&B1&A1 and Drug drop the formula and your series is done

     

    04760000000000001
    04760000000000001
    04760000000000002
    04760000000000002
    04760000000000003
    04760000000000003
    04760000000000004
    04760000000000004
    04760000000000005
    04760000000000005
    04760000000000006
    04760000000000006
    04760000000000007
    04760000000000007
    04760000000000008
    04760000000000008
    04760000000000009
    04760000000000009
    04760000000000010
    04760000000000010
    04760000000000011
    04760000000000011
    04760000000000012
    04760000000000012
    04760000000000013
    04760000000000013

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 09, 2019

krish86 , another variant without helper columns is to type first two numbers (as text, all cells are formatted as General), if they start from L4 in third cell (L6) is the formula

=LEFT(L5,LEN(L5)-8) & TEXT(RIGHT(L5,8)+MOD(ROW()-ROW($L$5),2),REPT("0",8))

select the column starting from L6 till end of your range and Ctrl+D (or drag this cell down).

Instead of eight that could be any number which is more than max number of digits at the end and less than 12.

 

 

Resources