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]+\)$', '')
:
User | Count |
---|---|
108 | |
84 | |
76 | |
54 | |
40 |