Thread: Delete cells with 0 as the tenth digit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PointerMan PointerMan is offline
external usenet poster
  
Posts: 33
Default Delete cells with 0 as the tenth digit
How do I delete cells with zero as the tenth digit? I've tried using the
formula =IF(MID(AE2575,10,1)="0",1,AE2575) but it doesn't return the actual
cell value if the tenth digit isn't zero.

Any ideas?
Reply With QuoteReply With Quote