If cell contains ( ) then enter value to another cell in same row

[solsearcher]

I have a large excel sheet that contains various columns containing data for products. The "A" column contains Product Reference and the "N" column contains live stock values.
I am trying to get rid of all products with a zero stock level, the problem is the master product has a zero value in the "N" column so if I delete all zero value products I'll loose my master product. Here is an example of my "Product Reference" for a product:

002320 BLU
002320 BLU(L)
002320 BLU(M)
002320 BLU(S)
002320 BLU(XL)
002320 BLU(XXL)

Is it possible to run a macro that will look in column "A" for the ( character and place a value of 500 in the corresponding "N" column cell? I choose 500 so that I can then remove all products with a zero value and will know that all values with 500 are master products.

Hope this makes sense.

[kbkumar]

Hello - welcome to the forum. I think you need to provide more details and upload a sample workbook as its not very clear with the info you have provided.

[FDibbins]

try this, assuming you're data starts in A1...

=IF(ISNUMBER(SEARCH("(",A1,1)),500,0)

[solsearcher]

Thanks FDibbins, just what I wanted!!!

[Solved]