HELP WITH FORMULA
Thanks for reply
Your formula helped thanks once again
-----Original Message-----
If Tom's suggest is no good... It seems your formula is
doing the opposite
of what you say you want. Anyway maybe:
=IF(OR(LEFT(A1,1)="1",LEFT(A1,1)="0"),MID(A1,2,10 0),A1)
--
Jim Rech
Excel MVP
.
|