This formula checks if an open parenthesis "(" exists in cell A1 by using `ISNUMBER(FIND("(", A1))`. If it does, the formula proceeds to extract the data inside the brackets using the `MID` function. If there's no open parenthesis, it returns an empty string, effectively making the cell blank.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item.
If the post was useful in other ways, please consider giving it Like.