How to Revert an Excel Formula

[RK_Thakur]

I converted Mi185043 to SEPCC1309185043 with this formula: =(CONCATENATE("SEPCC",(IF(LEN((CODE(UPPER(MID(A2,1,1))))-64)=1, CONCATENATE("0",((CODE(UPPER(MID(A2,1,1))))-64)), ((CODE(UPPER(MID(A2,1,1))))-64))),(IF(LEN((CODE(UPPER(MID(A2,2,1))))-64)=1, CONCATENATE("0",((CODE(UPPER(MID(A2,2,1))))-64)), ((CODE(UPPER(MID(A2,2,1))))-64))),(MID(A2,3,(LEN(A2)-2)))))

How do I revert SEPCC1309185043 back to Mi185043 ? Please help !!

 

[vletm]

RK_Thakur
You sent one sample.
This could revert with formula ="Mi" & right(A3,6)
If You have more variations, then formula could be different.

 

[bosco_yip]

Or………..

B2: SEPCC1309185043

C2, enter formula :

=CHAR(64+MID(B2,6,2))&LOWER(CHAR(64+MID(B2,8,2)))&MID(B2,10,99)

C2 result : Mi185043

Regards
Bosco

 

[RK_Thakur]

Or………..

B2: SEPCC1309185043

C2, enter formula :

=CHAR(64+MID(B2,6,2))&LOWER(CHAR(64+MID(B2,8,2)))&MID(B2,10,99)

C2 result : Mi185043

Regards
Bosco

Thanks a lot Bosco!! This worked.

Actually I have l list of hundreds of such codes which I needed to revert.

Thanks again! You are awesome