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)
<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