Separate Cells 2

[PL]

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

 

[Sheeloo]

Search and replace '(' and ')' with nothing
Then use Data->Text to columns option with delimiter as SPACE

 

[Jacob Skaria]

With your data in ColA cell A1

In B1
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)+0
In C1
=SUBSTITUTE(MID(A1,FIND("(",A1,FIND(B1,A1))+1,10),")",)+0

If this post helps click Yes