Remove characters before and after, remove zero and add letter

[sholleman]

[TABLE="width: 320"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TABLE="width: 256"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD="colspan: 4"]This is what I have:

000901000017 00068794 0 CA
[/TD]
[/TR]
[TR]
[TD="colspan: 4"]000901000024 00014544 0 CA
[/TD]
[/TR]
[TR]
[TD="colspan: 4"]000901000079 00068796 0 CA
[/TD]
[/TR]
[TR]
[TD="colspan: 4"]000901002004 00050853 0 CA
[/TD]
[/TR]
[TR]
[TD="colspan: 4"]000901016315 00068793 0 CA
[/TD]
[/TR]
[TR]

[/TR]
[TR]
[TD="colspan: 4"]This is what I want: (only second column, remove zeros in front, add a k in front)

[TABLE="width: 64"]
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"]k68794[/TD]
[/TR]
[TR]
[TD]k14544[/TD]
[/TR]
[TR]
[TD]k68796[/TD]
[/TR]
[TR]
[TD]k50853[/TD]
[/TR]
[TR]
[TD]k68793[/TD]
[/TR]
[TR]

[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD="colspan: 5"][/TD]
[/TR]
[TR]
[TD="colspan: 5"]These are the formulas I use but would like just one formula to do it all at once.
[/TD]
[/TR]
</tbody>[/TABLE]


=RIGHT(A1, LEN(A1)-17)
=LEFT(F2, LEN(F2)-13)
add column of "1" then =I3*K3

 

[jimrward]

can you show an example of source data and what it should look like afterwards

 

[sholleman]

Sorry, in A1 here is what I have:

000433821494 00114424 0 CA
000433821500 00114425 0 CA
000433821517 00114427 0 CA
000645000670 00234411 0 CA

I only want second column, remove zeros in front, add k to front.
Thank you.