Insert Number in Between String

[muhammad susanto]

hi all..

how to insert this number 5 digits

entry	expected result
1	LPK-00001/1/1/WKN.03/KNL.03/01.00/2018
15	LPK-00015/1/1/WKN.03/KNL.03/01.00/2018
326	LPK-00326/1/1/WKN.03/KNL.03/01.00/2018

<thead>
</thead><tbody>
</tbody>

any helps..thanks..

m.susanto

 

[Peter_SSs]

One way:
="LPK-"&TEXT(A1,"00000")&"/1/1/WKN.03/KNL.03/01.00/2018"

 

[muhammad susanto]

thanks Peter...

 

[Peter_SSs]

thanks Peter...

You're welcome.
Actually, you could save a few keystrokes with this if you want.

=TEXT(A1,"LPK-00000")&"/1/1/WKN.03/KNL.03/01.00/2018"