View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hammer_757[_3_] Hammer_757[_3_] is offline
external usenet poster
 
Posts: 1
Default search for absense of data


I am working with a spreadsheet that is being used primarily as
database with several elements of alphanumeric data in each cell.
need to search for cells that are missing an element “(3-2)” and the
search for something else “P POS” within the cell, replace it wit
something, and continue checking the remaining cells. If a cell ha
“(3-2)” in it I need to bypass the cell.

I cannot just search for “P POS” because it needs to remain in th
cells that contain (3-2).

For starters, I cannot seem to figure out how to find the absence o
something…

Thanks in advance
Rober

--
Hammer_75
-----------------------------------------------------------------------
Hammer_757's Profile: http://www.excelforum.com/member.php...nfo&userid=741
View this thread: http://www.excelforum.com/showthread.php?threadid=31399