Thread: HELP WITH FORMULA
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
  
Posts: 2,718
Default HELP WITH FORMULA
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,100 ),A1)

--
Jim Rech
Excel MVP


Reply With QuoteReply With Quote