How to increment the number using cell value

Hi Team,

I have "50" in column A and BA in Column B. If the length of column B is equal to 2 then the Column A number should include next series number to it.

Input
Column A	Column B
50	AC
49	A

Output
Column A	Column B
5051	AC
49	A

Data Investigation

Accepted answers

@Gsiva3 one way of doing this

increment_Cell_Value_06082024.yxmd

All comments

@Gsiva3 one way of doing this

increment_Cell_Value_06082024.yxmd

Thanks for the workflow. It worked!!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703