Syntax producing an error

Dear Sir,

I have a below formula used.

=IF(SEARCH("TOTAL",H4)="TOTAL","",D4)

Here,I am finding/Searching the the text "TOTAL" from H4,if there it exist then,it will return to space, else it will return the data that exit in D4.Currently it is producing an error.

Kindly see where I am wrong in the syntax.

With Best Rgds,
Suresh

Hi,

Better go for =SUBSTITUTE(

Provide a sample work book

Punnam

Thanx both of you,that's work great.

Here, I want to add one more condition.If H4 is equal to either "TOTAL" after seaching or equal to "" (space), then it will produce the result with "" else D4.

Now here how to club this condition into above formula.

Thanks once again.

suresh

Oh! I forget about OR,function.Yeah OR is the perfect here.
Thanx for your reply.

Last but not least,If H4 which is searching from "TOTAL",if I want to extract whole texts that contains the text "TOTAL" then in this condition how would be your formula ?

With Best Rgds,
suresh