View Single Post
  #1   Report Post  
Jaldhi Shukla
 
Posts: n/a
Default how can excel recognize strikethrough?

I am preparing an ACCESS table using apend query from a excel worksheet. I
identify deleted data in excel worksheet by striking through it rather than
completely deleting it.

But i do not want this striked through data to come to access table. is
there a way in which i can automatically do this? or can i set up excel to
return me any specific character in one cell to indicate that that row is
deleted. so i can inturn use that in access.

Thanks