Hi

I have a formula which is starting to get beyond my knowledge, I don't know
where to put the OR!

=IF(LEFT(C10,1)="F","AC"&MID(C10,2,7),"AC"&MID(C10 ,1,7))

My problem is I would like to test if the 1st character is an F or 0 then
drop it, but I still need an 8 digit account number. I can see from the
help it is possible but whereever I put it I just get an error in the
formula

Can anyone help?

Thanks

Wendy