Hello all,
I want to remove text within parentheses. I use substitute formula but it does not work. Can anyone help me?
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
It does not erase all the text in parentheses in second one. How to fix this?
Can you mention what is the original text for the second one?
Maybe this ?
index(split([Col],"("),1)
Nice, compact one @Koichi_Tsuji 👍
User | Count |
---|---|
33 | |
30 | |
29 | |
20 | |
18 |