Search and replace '(' and ')' with nothing
Then use Data-Text to columns option with delimiter as SPACE
"PL" wrote:

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