Is there a way that I can split some exported data into two fields?
The data per cell is in the format of:
Simon Williams (14/5/1986)
Alan Wilson (18/2/1965)
The Dates are always in brackets.
I'd like to display the text in one column, and the date in another (without the brackets)