Remove characters before and after, remove zero and add letter

[sholleman]

These are the formulas I use but would like just one formula to do it all at once.

<colgroup><col span="5"></colgroup><tbody>

This is what I have: 000901000017 00068794 0 CA

000901000024 00014544 0 CA

000901000079 00068796 0 CA

000901002004 00050853 0 CA

000901016315 00068793 0 CA

This is what I want: (only second column, remove zeros in front, add a k in front) k68794 k14544 k68796 k50853 k68793 <colgroup><col style="width:48pt" width="64"> </colgroup><tbody> </tbody>

<colgroup><col span="4"></colgroup><tbody>
</tbody>

</tbody>

=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.