find if concatenate function

[tushararora]

Hi

Cell A1 = Graphite Industries Limited (

Cell A2 should have : if cell A1 contains "(" then result should cell A1 otherwise concatenate "Add open Bracket"

[FDibbins]

Maybe...
=if(isnumber(find("(",a1,1)),A1,"add open bracket")

What exactly are you trying to do here?

[tushararora]

thanks it worked!

[FDibbins]

Happy to help, thanks for the feedback