I have a lenghty list of data all within one column (ie; rows 1 - 2000).
All of the data consists of a branch name followed by some figures in
brackets, ie:

Southampton (12345-654)

Is there a way that I can 'trim' the data to remove everything within the
brackets, including the brackets themselves?