View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
 
Posts: 383
Default Find / Compare Text in 2 different cells

hi, am trying to test if left 2 characters in 1 cell, is equal string of
characters in another cell. e.g.:

Cell A5: F00
Cell $A$3: A0 B0 C0 D0 E0 F0

Problem: does the left 2 characters "F0" exist in cell $A$3
thanks.....