How to Remove 0's

[Vinod]

Hi All,

How to remove zero's after GR008JP02A and keep the last numbers.

Thanks,

Vinod

[Jacek]

=left( [Branch Code], 10) & Num( right( [Branch Code], 5))

[Vinod]

Particularly for this Code-GR008JP02A , I wan't the result. and Upper Expression is not working also.

[Jacek · Accepted solution]

I see that only for this code you want to apply change. Right? Just add if :

if( left( [Branch Code], 10) = 'GR008JP02A' , 'GR008JP02A' & Num( right( [Branch Code], 5)), [Branch Code])