How to separate a text string into two columns?

Good morning everyone.
I don't know if the question has already been done. If so, I beg your pardon. I searched the forum but I have not found anything.

The question is: I have to separate a string of text in two columns. The string consists of the Italian title of a novel, followed by the original title, wich is enclosed in parentheses. Obviously, the length of the Italian title is variable, and therefore I'm not able to transfer to an adjacent column only the part related to the original title. I also have to remove the parentheses.
How can I do it?

Thank you for the help.

P.S. As usual, I apologize for my imperfect English.

Is there any seperator for italian and original title?

can you pls give an example?

Post a few examples of what your data looks like. You should be able to split it using the parentheses with FIND or SEARCH along with LEFT and RIGHT.

Pete

Originally Posted by Pete_UK

Post a few examples of what your data looks like. You should be able to split it using the parentheses with FIND or SEARCH along with LEFT and RIGHT.

Pete

This is my sheet.

Thank you

Simple method is to go to Data>.Text to column>>Delimited>>put '(' in others and next

You may have to replace ')' with blank in the result to get rid of the paranthesis at the end

oh.. I am late and the above solutions are perfect for you....

Originally Posted by Fotis1991

As i said

=IF(FIND(")";A1)-FIND("(";A1)>1;MID(A1;FIND("(";A1)+1;FIND(")";A1)-FIND("(";A1)-1);"")

Thank you, that's just what I needed

Thank you everyone.

Fotis1991 has solved the problem.