Formula question

[terrellchong]

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

[binu_acs · Accepted solution]

@terrellchong RegEx would work

Spoiler

[Christina_H]

If you want to avoid RegEx, you could also do this:

left([Name],FindString([Name]," ("))

This takes the left part of the name up to the brackets