=RIGHT(G4,LEN(G4)-IF(OR(MI

IF(OR(MID(G4,2,1)="0",MID(

IF(OR(MID(G4,3,1)="0",AND(

IF(OR(MID(G4,4,1)="0",MID(

IF(OR(MID(G4,5,1)="0",AND(

IF(MID(G4,6,1)="0",6,5),4)

instead of breaking it all out

right(text to look at, number of characters to take)

left(text to look at, number of characters to take)

mid(text to look at, first character to look at counting from left hand side, number of characters to take)

len(text to look at) gives the length in characters of this text.

and(x,y,z) is the same as - x and y and z in normal programming. all of them must be true or false is returned.

or(x,y,z) is the same as - x or y or z in normal programming. If any of them are true, the entire set is true.