Splitting text & number

[ImanJanahmadi]

I need help to spilt text and numbers! 
what I have is: Jackson, Tom (A123456)
What I need is: Jackson, Tom

Thank you for help. 
Iman 

[Deano478]

Hey @ImanJanahmadi  stick this into a formula tool and it will do the trick

REGEX_Replace([Field1], '\s\([A-Z0-9]+\)$', '')

:

[binu_acs]

@ImanJanahmadi another method