View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davemorrison
 
Posts: n/a
Default using IF function to copy, but leave populated cell alone

you are asking
if A2 = Example Text then Example Text
if not then Blank

is this what you want??

maybe
=if(A2="Example Text","",A2)