Fill Series Number in Keep 5 Digits

[muhammad susanto]

hi all...

how to make fill series like this :

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]LPK-00008/1/1/WKN.03/KNL.03/01.00/2018[/TD]
[/TR]
[TR]
[TD]LPK-00009/1/1/WKN.03/KNL.03/01.00/2018[/TD]
[/TR]
[TR]
[TD]LPK-00010/1/1/WKN.03/KNL.03/01.00/2018[/TD]
[/TR]
[TR]
[TD]etc...[/TD]
[/TR]
[TR]
[TD]LPK-00125/1/1/WKN.03/KNL.03/01.00/2018[/TD]
[/TR]
</tbody>[/TABLE]

my goal in red font..always keep 5 digits number..

any help much appreciated...

m.susanto

 

[István Hirsch]

Does this work for you?

="LPK-"&TEXT(ROW()+7,"00000")&"/1/1/WKN.03/KNL.03/1/2018"

 

[muhammad susanto]

hi Istvan....thank but why use Row combine? It's possible without use Row?

 

[Marcílio_Lobão]

muhamma susanto, Good afternoon.

"...but why use Row combine?..."

Using the ROW() function is a trick to generating an automatic numerator for when the formula is copied down.

In this case ROW()+7 is due to your first example that shows the number 00008.
Then in this case, the formula must be pasted on line 1 of the worksheet to start the numbering in 00008.

You can also start numbering in the number you decide and put the formula initially where you want.

Just use ROW(A1) or ROW(A8).

In this case the numbering will obey what is within the parenthesis.

The letter of the column makes no difference at all.
If you prefer you can use ROW(M1) or ROW(S8)

I hope I've helped clarify this little doubt.

Have a nice day!

 

[István Hirsch]

Copy the first item into cell A1, then copy the formula in A2 and copy down:

Excel Workbook
	A
1	LPK-00008/1/1/WKN.03/KNL.03/01.00/2018
2	LPK-00009/1/1/WKN.03/KNL.03/01.00/2018
3	LPK-00010/1/1/WKN.03/KNL.03/01.00/2018
4	LPK-00011/1/1/WKN.03/KNL.03/01.00/2018
5	LPK-00012/1/1/WKN.03/KNL.03/01.00/2018
6	LPK-00013/1/1/WKN.03/KNL.03/01.00/2018
7	LPK-00014/1/1/WKN.03/KNL.03/01.00/2018
8	LPK-00015/1/1/WKN.03/KNL.03/01.00/2018
9	LPK-00016/1/1/WKN.03/KNL.03/01.00/2018
10	LPK-00017/1/1/WKN.03/KNL.03/01.00/2018
Sheet1