Thread: Delete cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Delete cells
"=MATCH(LEFT(RC2,LEN(RC2)-8),C1,0)"

The OP said "if their left 16 characters do not match..." so why LEN-8
instead of 16?

Rick Rothstein (MVP - Excel)

Reply With QuoteReply With Quote