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

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you have 365 how about

=textafter(a2,"_")

 

[daza34]

Hi,

I have 365 and I just get #NAME?

 

[Fluff]

That suggests you do not have the latest updates, try running an update.

 

[kvsrinivasamurthy]

Try

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

 

[Fluff]

If you cannot update Office, then another option is

=REPLACE(A2,1,FIND("_",A2),"")

 

[daza34]

I have updated before and the others aren't working

 

[Fluff]

Have you tried the other two suggestions?

 

[kvsrinivasamurthy]

Have you tried post #5.
If still you have problem upload file.

 

[daza34]

Hi,

=MID(A2:A14,FIND("GBR",A2:A14),200 worked (THANK YOU) but what if i wanted it to find ROI in the same formula please?