Substitute to remove text within parenthesis

[maxmaxmax222]

Hello all,

I want to remove text within parentheses. I use substitute formula but it does not work. Can anyone help me?

[Suvrutt_Gurjar]

Such expressions can be a bit tricky as slight variation in requirement could cause issues in result but you could try

LEFT([TextString], LEN([TextString])-FIND(“(”,[TextString])-1)

where the [TextString] contains a string as below you have given

[maxmaxmax222]

It does not erase all the text in parentheses in second one. How to fix this?

[Suvrutt_Gurjar]

Can you mention what is the original text for the second one?

[Koichi_Tsuji]

Maybe this ?

index(split([Col],“(”),1)

[Suvrutt_Gurjar]

Nice, compact one @Koichi_Tsuji