|This cannot be done in the cell that currently contains the text unless you use VBA (a macro).|
If you are willing to use another cell, then this formula should work:
With KCT in A1 and KPO_ALC_SH_02 in B1, put this formula in C1:
This will concatenate the value in A1 to the "right side" of B1, minus the first 3 characters of B1.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.