I WANT TO FILL SERIES NUMBERS AS ATTACHED. PLEASE CAN YOU HELP ME OUT ON THIS.
View best response
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
THANKS. IT WORKS
@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.
@Sergei Baklan GOOD ONE. THANKS
@krish86 , you are welcome