Separate Cells 2
 

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

Separate Cells 2
 

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

Separate Cells 2
 

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
---------------
Jacob Skaria


"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