Hi Guys,
Can some one help me? I have tried to apply a formula to this without much success.Can someone help me??I just want to be able to total the amount. I have used this =IF(RIGHT(B2,2)="cr",LEFT(B2,LEN(B2)2),CONCATENATE("",LEFT(B2,LEN(B2)2)))
Can some one help me? I have tried to apply a formula to this without much success.Can someone help me??I just want to be able to total the amount. I have used this =IF(RIGHT(B2,2)="cr",LEFT(B2,LEN(B2)2),CONCATENATE("",LEFT(B2,LEN(B2)2)))
Attachments

89.3 KB Views: 6
Last edited: