AnsweredAssumed Answered

Any simple way to create this calculation?

Question asked by jiang_aq on May 1, 2018
Latest reply on May 1, 2018 by okramis

My demand is:

 

the seats number are like:

 

1A

2A 2D 2E

3A 3D 3E

4A 4D 4E

5A 5D 5E

 

If input 2ADE or 2A 2D 2E, then convert into 2A2D2E instead

If input 2A 3DE 4ADE, then convert into 2A 3D3E 4A4D4E instead

 

Any suggestion? Thanks!

Outcomes