View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
SUZZI SUZZI is offline
external usenet poster
 
Posts: 5
Default 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


.