Hi,
I have text in column A that I need to extract part of it to put in column B, Everything from were it says GBR to the right, (example GBR-R-02240_13121)
Please help
I have text in column A that I need to extract part of it to put in column B, Everything from were it says GBR to the right, (example GBR-R-02240_13121)
Please help
a | B |
CM DAN36 HW_GBR-R-02240_13121 | |
CM DANS120-24 MLI_GBR-R-00064_6 | |
CM DAN36 HW_GBR-R-02240_13123 | |
CM DANS120-24 HW_GBR-R-00064_5 | |
CM DAN36 HW_GBR-R-02240_13125 | |
CM WAN674g MLI_GBR-R-00164_11_13126 | |
CM DAN36 HW_GBR-R-02240_13127 | |
CM DANS210-48 HW_GBR-R-00064_3 | |
CM DAN36 HW_GBR-R-00189_43 | |
CM DANS210-48 MLI_GBR-R-00064_2 | |
CM DANS210-48 HW_GBR-R-00064_1 | |
CM DAN36 MLI_GBR-R-06461_54025 | |
CM DAN36 HW_GBR-R-06461_54024 |