Specific Text Removal

[daza34]

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

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

 

[kvsrinivasamurthy]

What is ROI.

 

[daza34]

If it also said ROI and GBR, so hypothetically looking for both.

CM DANS210-48 MLI_ROI-R-00064_2
CM DANS210-48 HW_GBR-R-00064_1
CM DAN36 MLI_ROI-R-06461_54025
CM DAN36 HW_GBR-R-06461_54024

 

[Rick Rothstein]

Did you update your 365 and, if so, does the TEXTAFTER function work for you now?

 

[Rick Rothstein]

It looks like you have been back on this thread for about 10 minutes, and, for whatever reason, you have not answered my question yet. So I'll assume you are fully updated now and working. With that said, give this single formula (it will spill the desired results) a try (change the two ranges to match the actual location of your data)...

=SUBSTITUTE(A1:A4,TEXTBEFORE(A1:A4,{"GBR","ROI"}),"")

 

[kvsrinivasamurthy]

Try

=MID(A2:A14,IFERROR(FIND("GBR",A2:A14),FIND("ROI",A2:A14)),200)