Dear all,

Please help me with this;

If column A1 i have "T0021114", and column B1 I want it automatically appear "T0021114Z". How should I go about it.