Remove information in brackets

[Butch-196]

Project - Document list

12282-GEN-00013-3.3.1 (ID01)	12282-GEN-00013-3.3.1
12282-GEN-00016-3.3.2 (ID01)	12282-GEN-00016-3.3.2
12282-GEN-00019-3.3.3 (ID01)	12282-GEN-00019-3.3.3
12282-GEN-00022-3.3.4 (ID01)	12282-GEN-00022-3.3.4
12282-GEN-00025-3.4 (ID01)	12282-GEN-00025-3.4
12282-GEN-00028-3.4.1 (ID01)	12282-GEN-00028-3.4.1
12282-GEN-00031-3.4.2 (ID01)	12282-GEN-00031-3.4.2
12282-GEN-00034-3.4.3 (ID01)	12282-GEN-00034-3.4.3
12282-GEN-00037-3.4.4 (ID01)	12282-GEN-00037-3.4.4
12282-GEN-00040-3.4.5 (ID01)	12282-GEN-00040-3.4.5

I need a formula to turn column A into column B - remove the information in brackets. Thanks Richard

 

[Eric W]

Try:

=REPLACE(A2,FIND(" (",A2),99,"")

if the part in parentheses is always at the end.

 

[GlennJ]

If say B5 has the info you need to fix up then =LEFT(B5, LEN(B5)-6)

 

[Butch-196]

Try:

=REPLACE(A2,FIND(" (",A2),99,"")

if the part in parentheses is always at the end.

thanks