move data to other column based on a condition

[duwell81]

i have a spreadsheet that has data in column a that varies in format with some of the data. I am trying to retreive all data that is after the right parenthesis in some of the rows in column A. I want to extract that data and put it in another column such as I or K one row down from the row its located in. I would like to be able to change the column i want the data in before the code is run. An example is below.

Column A

R1 pci10(456392)lc41
R2 pci11(12345465)hp22
R3 pci56(43455)lc21
R4 hello34(43434)
R5 uouavib3040
R6 pci85(234A009)h30
R7 aassdlf0983
and so on......


After
Column K or or any other column I would choose to have my data put in after the parenthesis.

Column K
R1
R2 lc41
R3 hp22
R4 lc21
R5
R6
R7 hp30
R6
R7
and so on.....

 

[duwell81]

Thanks to all who responded and sorry to all for late reply. I checked back the first few days and saw no responses and I just checked back today and found all these answers. Wow great site and thanks for all the help. Wayne