To generate cell values based on condition

Gsiva3

Hi team,

Hi @Qiu 

I have a columns named A, length of A & 1st 2 characters from A. My request is that, if length of A column has a value of 4 means, then the value in 1st 2 characters from A column should get the next series of it. That is, if value in 1st 2 characters from A column is 01 means, when the length of A column value is 4, the output of the 1st 2 characters from A column should be 0102.

Is this possible to do.

Sample .xlsx

Qiu

@Gsiva3 

I believe yes.

0215-Gsiva3.yxmd