You can use the following calculated fields to do this:
SPLIT will break a string in pieces based on another string. So these split the string based on "(". The REPLACE will remove the closing paren.
See attached workbook.
If this helps to resolve your problem, please mark this as helpful or the "correct answer." This will help others with similar problems in the future. Thanks!
text to column.twbx 13.3 KB
This is great. Thanks Ken!