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
Hey @ImanJanahmadi stick this into a formula tool and it will do the trick
REGEX_Replace([Field1], '\s\([A-Z0-9]+\)$', '')
: