Insert Number in Between String

[muhammad susanto]

hi all..

how to insert this number 5 digits


[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]entry[/TH]
[TH]expected result[/TH]
[/TR]
</thead><tbody> [TR]
[TD]1[/TD]
[TD]LPK-00001/1/1/WKN.03/KNL.03/01.00/2018[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]LPK-00015/1/1/WKN.03/KNL.03/01.00/2018[/TD]
[/TR]
[TR]
[TD]326[/TD]
[TD]LPK-00326/1/1/WKN.03/KNL.03/01.00/2018[/TD]
[/TR]
</tbody>[/TABLE]


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"