Need help creating a formula that will remove a certain string of text.

Reginald

My use case is:

I need to remove everything within the parentheses and including the parentheses. Is this possible? I just need the name. I feel like the Replace, substitute or mid formula would put me in the right area but not able to figure it out.

Ex: John Doe (123456789)

Mark.poole

@Reginald

Try this.

=LEFT([Column Name]@row, FIND("(", [Column Name]@row) - 2)

Mark.poole

@Reginald

Try this.

=LEFT([Column Name]@row, FIND("(", [Column Name]@row) - 2)

Reginald

That worked. Thanks for the help!