Project - Document list
I need a formula to turn column A into column B - remove the information in brackets. Thanks Richard
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