Deleting cell content based on a criteria

Hi

just thought of a small problem. Is it possible to delete part of the cell cont based on a criteria

Ex. "HANS (SPIS),Hans,Hans" would it be possible to delete the brackets and the content within the brackets using formulas?


Thx in advance for any input

How about...

=SUBSTITUTE(A1,MID(A1,SEARCH("(",A1),SEARCH(")",A1)-SEARCH("(",A1)+1),"")

You're welcome…glad you have a workable solution and thanks for the feedback...