Ok. This is an eg of I have

XXXXXX (123) (456)
XX (789) (1011)

I want to Separate all the words and numbers into separate columns and I
want the brackets to be removed, so how do I do so?

Thanks