Hello,

How do i delete parts of information in a cell. I have over a thousand list of parts and I wanted to delete parts of the information in the cell without having to do it manually.

I was going to insert another column next to the Part numbers and wanted to have a formula where I can just drag down the cells.

Below are examples of some part numbers.

AS568-2-468 (S/T AS568-268V747-75)
AGS-3234TC-41-10145 (S/T AGS-3234TC-41-10-1/4S)
A06050062-001 (S/T 1222179-001)
Transportation (over & above) (GFY 13)
Transportation (Route Survey)
Transportation (GTM-1) (GFY 11)

I want to delete everything in the "( )" and keep everything below. Doing this manually will take a long time .



Thank you