Hi,
I have a question regarding on formula.
I understand that I need to use IF THEN ELSE statement for this. But I am currently stuck
So my problem is that I have this set of data in my dataset
| ID | Name |
| 1234 | Abc Corp (1234) |
| 1235 | Efg Corp (1235) |
How do I remove the number in the name so that it appears to be like the following output?
| ID | Name |
| 1234 | Abc Corp |
| 1235 | Efg Corp |
