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.

[Qiu · Accepted solution]

@Gsiva3 

I believe yes.

[Gsiva3]

Thank you so much @Qiu 

Got it !!!

Can you please explain this formula for my better uderstanding.

[Qiu]

@Gsiva3 

So if the length is not 4 then take the first two characters.

If it is 4, then take first two letters and change to number, then add 1 then change it to string, then add 0 with padleft function then add to the original first 2 characters.